See the Exhibit and examine the structure of the PROMOTIONS table:Exhibit:Using the PROMOTIONS table, you need to find o
Posted: Wed Jun 07, 2023 6:12 am
See the Exhibit and examine the structure of the PROMOTIONS table:Exhibit:Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.You issue the following SQL statements:Exhibit:What would be the outcome?
A. It generates an error because multiple conditions cannot be specified for the WHEN clause
B. It executes successfully and gives the required result
C. It generates an error because CASE cannot be used with group functions
D. It generates an error because NULL cannot be specified as a return value
- See The Exhibit 1 (83.03 KiB) Viewed 180 times
- See The Exhibit 2 (3.13 KiB) Viewed 180 times
B. It executes successfully and gives the required result
C. It generates an error because CASE cannot be used with group functions
D. It generates an error because NULL cannot be specified as a return value