View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.Evaluate the following SQL statements:Wh
Posted: Wed Jun 07, 2023 6:12 am
View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.Evaluate the following SQL statements:Which statement is true regarding the output of the above query?
A. It gives details of product IDs that have been sold irrespective of whether they had a promo or not
B. It gives the details of promos for which there have been no sales
C. It gives the details of promos for which there have been sales
D. It gives details of all promos irrespective of whether they have resulted in a sale or not
- View The Exhibi 1 (83.44 KiB) Viewed 168 times
- View The Exhibi 2 (38.74 KiB) Viewed 168 times
- View The Exhibi 3 (1.21 KiB) Viewed 168 times
B. It gives the details of promos for which there have been no sales
C. It gives the details of promos for which there have been sales
D. It gives details of all promos irrespective of whether they have resulted in a sale or not