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 user-defined 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 4 start rating, 'Good' if it has above 3.5 and below 4 star rating. 'Average' if it is above 3 and below 3.5 and 'Bad' if it is below 3 star rating and
Find the Ceil, floor and absolute values of the rating column and display the current date and separately display the year, month_name and day.
Display the restaurant type and total average cost using rollup.
 You work for a data analytics company, and your client is

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!