Foodltem itemID, name, calories, price Order orderID, Date Customer custID, name, creditCardNum, bdate PartOfOrder order
Posted: Sun May 15, 2022 8:51 am
- Foodltem Itemid Name Calories Price Order Orderid Date Customer Custid Name Creditcardnum Bdate Partoforder Order 1 (38.63 KiB) Viewed 32 times
A)Find the name and custID of all customers born on
1999-12-31
B)Find the name of customers who have ordered (any quantity
>= 1) the food item “smellyFish” on 2019-01-01.
C)A new manager has decided all food items will cost $1, $2, $5,
$10, or $20. Find the average number of calories for all food items
that cost the same amount for each of the different dollar amounts.
Your query should be flexible to adding new/different dollar
amounts; hence, it should work for any number of price groups.
Foodltem itemID, name, calories, price Order orderID, Date Customer custID, name, creditCardNum, bdate PartOfOrder orderID, itemID, quantity PlacedOrder orderlD, custID