Question: BART B: RESTAURANT_ORDERS: 6. 10. List customers who placed orders with at least one restaurant with headquarters in their own hometown (e.g., Sheldon's hometown is

BART B: RESTAURANT_ORDERS: 6. 10. List customers who placed orders with at least one restaurant with headquarters in their own hometown (e.g., Sheldon's hometown is Houston and orders from ? Display the Customer name, Hometown, Restaurant name, and Restaurant's headquarters. Find the total number of distinct dishes prepared in each restaurant headquartered in either Houston or Los Angeles. Display Restaurant name and dish count in results table. List the dishes that Leonard has ordered. Display the Dish name, List price (rounded to the nearest dollar and preceded with a 35 sign) and calories information for the dishes. Get the total quantity for all orders made by each customer of BBQbaconBurger dish. Display the customer number and total quantity labeled as "total BBQ bacon burger consumed". Sort the results in the descending order of total quantity. For dishes with city of origin as 'Boston', get the total purchase [sum of price per order] for each dish per restaurant. Print the dish name, restaurant name, and the total purchase. Round the total purchase column to nearest dollar. Sort the results by dish name and restaurant name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
