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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!