In the next marketing campaign, the company wants to offer some promotion to its existing customers in a chosen city. To help the manager decide on the city to run the campaign and the list of promoted products that can lead to a successful campaign, please: - Propose a suitable ranking criterion to choose the city (provide justification) - Propose a ranking criterion you think is best suit to choose the products (provide justification). - Provide the corresponding code to return: + the most favourite city based on your criterion. + the list of top five promoted products based on your criterion. sql query