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:

Post a Comment

0 Comments