Introduction

This week you will be retrieving the records from the Food Order App database. All the create and insert operations should be performed using MySQL$.$ Before proceeding with the task make sure you have the Food Order App database created with enough records in the database. You can follow the below mentioned steps to create the database and insert records in the database$-$

$1.$ Downloadand extract the SQL$3$ Assessment folder from the zip folder provided under the Source Code section. All the necessary files are provided within this folder.

$2.$Open MySQL Workbench.

$3.$ In MySQL Workbench $,$ open the FoodOrderApp$\_$DDL Commands.sql file provided in the Source code folder and execute this file to create the database and the tables in the database.

$4.$ You can refer to the FoodOrderApp$\_$Database$-$ Design Document.pdf and FoodOrderApp$\_$ER Diagram.pdf files provided in the source code to understand the design of the database.

$5.$ Now open the FoodOrderApp$\_$Insert Commands.sql file in the MySQL workbench and execute it to insert the records in the tables.

$6.$ Now open the SelectQueries$1.$sql file to write and execute the SQL queries as mentioned in the task$1$ below.

$7.$ Then open the SelectQueries$2.$sql file to write and execute the SQLqueries as mentioned in the task$2$ below.

Problem Statement

Your task is as follows$-$

$1.$Retrieve records $($SelectQueries$1.$sql file$)(3$ points each$)$

$1\mathrm{.}1.$ Display all cuisine names.

$1\mathrm{.}2.$ Display description of'Cake'category.

$1\mathrm{.}3.$ Select all restaurants where restaurant names end with'Junction'.

$1\mathrm{.}4.$ Display details of all vegetarian food items.

$1\mathrm{.}5.$ Retrieve all menu items with food items that have a price equal to or less than $$10.$

$1\mathrm{.}6.$Retrieve cartId having the maximum number of food items.

$1\mathrm{.}7.$Retrieve all the shipping details where emailId contains'doe'.

$1\mathrm{.}8.$ Retrieve the order with the highest price.

$1\mathrm{.}9.$ Retrieve the most recently updated order.

$1\mathrm{.}10.$ How many total units of food items were purchased in orderId $1?$

$2.$Retrieve records $($Select Queries$2.$sql file$)(6$pointseach$)$

$2\mathrm{.}1.$ Retrieve number of food items for each cuisine

$2\mathrm{.}2.$ Retrieve category names in the order of highest to lowest no$.$of food items

$2\mathrm{.}3.$Retrievecuisine name as Cuisine Name, food item name as name Food Item Name and description as Description of all the food items belonging to'Italian'cuisine.

$2\mathrm{.}4.$ Retrieve details of food items, including their name, vegetarian status,and cuisine name,for only those food items that are vegetarian.

$2\mathrm{.}5.$ Retrieve the details of users who have items in their cart along with the total order amount.