Question: You work for a data analytics company, and your client is a food delivery platform similar to Jomato. They have provided you with a dataset
You work for a data analytics company, and your client is a food delivery platform similar to Jomato. They have provided you with a dataset containing information about various restaurants in a city. Your task is to analyze this dataset using SQL queries to extract valuable insights and generate reports for your client.
Tasks to be performed:
Create a userdefined functions to stuff the Chicken into 'Quick Bites'. Eg: 'Quick Chicken Bites'.
Use the function to display the restaurant name and cuisine type which has the maximum number of rating.
Create a Rating Status column to display the rating as 'Excellent' if it has more the start rating, 'Good' if it has above and below star rating. 'Average' if it is above and below and 'Bad' if it is below star rating and
Find the Ceil, floor and absolute values of the rating column and display the current date and separately display the year, monthname and day.
Display the restaurant type and total average cost using rollup.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
