Question: Part 1 (worth 4 points each) 1. Using the IN clause, write a query to display the Top 5 rated restaurants (restaurant names, city and
Part 1 (worth 4 points each) 1. Using the IN clause, write a query to display the Top 5 rated restaurants (restaurant names, city and rating fields) located in either of the two cities, 'Bangalore' or Rename the column name of the restaurant as 'Best Restaurant' and sort by descending order of rating. 2. Using the Orderltem table, write a query to display each Item ID and sum of quantity ordered for each item as TotalQuantity. Sort by TotalQuantity descending 3. Write a query to display customer's first name, last name, email address and phone number from the Instafood database. Rename the column name as 'Customer Info'. The information should be displayed as follows: The email address of Sasidhar Adi is sasiadi@gmail.com and contact number is 9434545566 4. From the Payroll table, write a query to display the Employee ID and the number of Incentives used by the Employee. Display only those who have had more than 1 incentive Part 1 (worth 4 points each) 1. Using the IN clause, write a query to display the Top 5 rated restaurants (restaurant names, city and rating fields) located in either of the two cities, 'Bangalore' or Rename the column name of the restaurant as 'Best Restaurant' and sort by descending order of rating. 2. Using the Orderltem table, write a query to display each Item ID and sum of quantity ordered for each item as TotalQuantity. Sort by TotalQuantity descending 3. Write a query to display customer's first name, last name, email address and phone number from the Instafood database. Rename the column name as 'Customer Info'. The information should be displayed as follows: The email address of Sasidhar Adi is sasiadi@gmail.com and contact number is 9434545566 4. From the Payroll table, write a query to display the Employee ID and the number of Incentives used by the Employee. Display only those who have had more than 1 incentive
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
