Question

8) Develop an SQL query to determine which holiday had the most sales and then drill down via another query to determine for that holiday which dealership had the most sales. Then drill down by another query to determine for that holiday which dealership, by zip code, and make had the most sales.

Answer 1

`Hey,

Note: Brother if you have any queries related the answer please do comment. I would be very happy to resolve all your queries.

SELECT SALE_DAY

FROM TIME

WHERE SALE_DAY IN (SELECT SALE_DAY

FROM ( SELECT T.SALE_DAY,

RANK () OVER ( ORDER BY SUM (SF.GROSS_SALES_AMOUNT) DESC) DAY_RANK

FROM TIME T, SALES_FACTS SF

WHERE T.SALE_DAY = SF.SALE_DAY

AND DAY_TYPE = 'HOLIDAY'

GROUP BY T.SALE_DAY)

WHERE DAY_RANK = 1);

Kindly revert for any queries

Thanks.