Problem
Simple queries over the RESTAURANT_ORDERS database tables:
1. Display the count of customers whose hometown is either Boston or Houston.
2. Display the dishes which have Chicken in its name. Print the dishname, listprice, and calories.
3. Display the top three dishes in terms of the calorie count. Print the dishname, listprice, and calories.
HINT: Use the SORT function as well as FETCH NEXT N ROWNS only functionality of Oracle SQL.
4. Display the orders which have quantity more than 4 but price less than 10. Print all the rows of ORDERS table in the results table. Sort the table in terms of quantity and price.