Dataset: Jornato

About the dataset:

You work for a data analytics company, and your dient is a food delivery platform simiar 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\mathrm{.}5$ and below $5$ star rating. 'Average' if it is above $3$ and below $3\mathrm{.}5$ and 'Bad' if it is below $3$ star rating.

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.