Slip 11 - D) Consider the above tables and execute the following queries: 1. Display receipt which includes bill_no with Dish description, price, quantity and total amount of each menu. 2. Find total amount collected by hotel on date 09/07/2019. 3. Count number of menus of billno 301. 4. Display menu details having price between 100 and 500. 5. Display the tableno and day whose bill amount is zero.
Solution:
0 Comments