Question: Download the file Task_2_Code.sql to your computer and import it to your LDD account. The file will create a data warehouse for a sales schema
Download the file "Task_2_Code.sql" to your computer and import it to your LDD account. The file will create a data warehouse for a sales schema with five dimension tables (W_CUSTOMERS, W_PRODUCTS, W_STORES, W_SUPPLIERS, W_TIME) and one fact table (W_FACTS). The data warehouse covers the time period from January to December 2014. Use this schema to answer the following questions: 1- Write several queries to display the number of records in each table. 2- Which product generated maximum sales in Dec, 2014? 3- Which store produced highest sales in the whole year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
