[solved]-Using Customer Order Items Tables Last Week See Database Tables Write Nested Subqueries Di Q39072150

Using the Customer, Order, Items tables from last week (see the database tables below) write nested subqueries that display customer (s) who ordered soda or Hamburger and paid by credit. Your query should return Natalie Lopez If you do not have the following tables from previous activities, please create the table you need and populate them with the data provided. a. Customer table: Customer D Customer name William Smith 1 Natalie Lopez 2 3 Brenda Harper Adam Petrie b. Order table: OrderID CustomerID OrderType Amount Cash 1 1 122.25 Credit 2 2 11.75 Credit 2 5.00 4 2 8.00 Cash Credit 3 9.33 Credit 6 10.11 C. Items table: Order DitemiD Items 2 Bacon Clubhouse 1 2 Big Mac Soda A Hamburger A Double-burger 1 5 6 6 Ice cream Show transcribed image text Using the Customer, Order, Items tables from last week (see the database tables below) write nested subqueries that display customer (s) who ordered soda or Hamburger and paid by credit. Your query should return Natalie Lopez If you do not have the following tables from previous activities, please create the table you need and populate them with the data provided. a. Customer table: Customer D Customer name William Smith 1 Natalie Lopez 2 3 Brenda Harper Adam Petrie b. Order table: OrderID CustomerID OrderType Amount Cash 1 1 122.25 Credit 2 2 11.75 Credit 2 5.00 4 2 8.00 Cash Credit 3 9.33 Credit 6 10.11 C. Items table: Order DitemiD Items 2 Bacon Clubhouse 1 2 Big Mac Soda A Hamburger A Double-burger 1 5 6 6 Ice cream

Expert Answer

---

Answer to Using the Customer, Order, Items tables from last week (see the database tables below) write nested subqueries that disp… . . .