Use KimTay Pet Supplies Database to answer the following questions (Data files for the database can be found on myUnisa
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Use KimTay Pet Supplies Database to answer the following questions (Data files for the database can be found on myUnisa
questions (Data files for the database can be found on myUnisa module site under "additional resources" folder) 1.1. For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created. (4) 1.2. For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created. (5) 1.3. Use the IN operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021. (3) 1.4. Use the EXIST operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021. (6)
Use KimTay Pet Supplies Database to answer the following