A. Write an SQL query similar to SQL-Query-CH12-02 on page 551 that uses the total dollar amount of each day’s product sales as the measure (instead of the number of products sold each day). B. Write...

A. Write an SQL query similar to SQL-Query-CH12-02 on page 551 that uses the total dollar amount of each day’s product sales as the measure (instead of the number of products sold each day).

B. Write the SQL view equivalent of the SQL query you wrote to answer part G.

C. Create the SQL view you wrote to answer part H in your HSD_DW database.