Question: SQL Queries based on STAR schema Need to get help with 2 queries for the following database setup: LAB_CHANNELS_DIM (CHANNEL_ID, CHANNEL_DESC, CHANNEL_CLASS) LAB_CUSTOMERS_DIM (CUST_ID, CUST_FIRST_NAME,

SQL Queries based on STAR schema

Need to get help with 2 queries for the following database setup:

LAB_CHANNELS_DIM (CHANNEL_ID, CHANNEL_DESC, CHANNEL_CLASS)

LAB_CUSTOMERS_DIM (CUST_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_GENDER, CUST_YEAR_OF_BIRTH, CUST_MARITIAL_STATUS, CUST_STREET_ADDRESS, CUST_POSTAL_CODE, CUST_CITY, CUST_STATE_PROVINCE, CUST_MAIN_PHONE_NUMBER, CUST_INCOME_LEVEL, CUST_CREDIT_LIMIT, CUST_EMAIL)

LAB_PRODUCTS_DIM (PROD_ID, PROD_NAME, PROD_SUBCATEGORY, PROD_CATEGORY)

LAB_PROMOTIONS_DIM (PROMO_ID, PROMO_NAME, PROMO_SUBCATEGORY, PROMO_CATEGORY)

LAB_SALES_FACT (PROD_ID, CUST_ID, TIME_ID, CHANNEL_ID, PROMO_ID, AMOUNT_SOLD)

LAB_TIME_DIM (TIME_ID, FISCAL_MONTH, FISCAL_QUARTER, FISCAL_YEAR)

What were the genders for top 10 customers? (Use: Rank)

Which products are most profitable for a specific time period? (Use: Grouping Sets)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Requirements: In order to complete this, you will need to perform the following: Create tables Create key constraints Create check constraints Import data to the table (provided) Ensure bad data...

In Project Task 3 , you are required to write 1 2 SQL queries based on the tables from the provided relational model Download relational model. These queries are detailed in the task - 3 . sql...

Perform physical design for efficiency if necessary. Construct SQL statements for querying the database effectively. Details are provided in the assignment item Project Task 3 . In Project Task 3 ,...

SQL query help. SQL DIAGRAM Step 2: In step 3, you will be writing three SQL queries- all of which create a table. Your entire code will be based off the rules listed below. It will combine...

Question 4 (Covers LO 4) Take each of the normalized relations and implement them as SQL tables using your chosen DBMS from the previous task with a series of CREATE TABLE statements. You must...

Overview: In this assignment, you are given a database and a set of information requests. Use SQL commands to extract the required data, export it , and then apply data visualization techniques to...

Question 4 SQL (16 points) Write SQL queries based on the following two tables. For your understanding, the partial contents of the tables are shown, but assumes that there are many more rows (e.g.,...

Write the following SQL queries based on the following relational schema: Student(stdID: char(5), stdName:varchar(50), age: number, addr Course(crscode: char(5), crsName:varchar (50), crscredit:numbe...

Write the following SQL queries based on the database schema SALES (DEPT. ITEM, VOLUME) DEPT DNAME, FLOOR) ITEM (INAME, TYPE, COLOR) EMPLOYEE (ENO, ENAME, MGR. DEPT. SALARY, JOB-STATUS) SUPPLIER...

Please write SQL queries based on given relational schema Minimum total 15 queries, including ALL of the below: I. INSERT - at least 3 queries ii. UPDATE, DELETE- at least 3 queries iii. SELECT...

How does the Bank of Canada differ from other banks?

An electric room heater has been designed in the shape of a vertical cylinder 2 m tall and 30 cm in diameter. For safety, the heater surface cannot exceed 35?C. If the room air is 20?C, find the...

Question 4 1 1 pts The SEP 5 0 0 Index retumed: 5 . 1 % , 6 . 9 % , - 7 . 3 % , - 8 . 1 % , 7 . 2 % . Over the same period, BergAwesome Inc. had the following returns: 4 . 8 % , 7 . 3 % , - 6 . 2 % ,...

1.Sterne acquired 60% of the voting equity shares of Defoe. Defoe had the following equity at the date of acquisition: $ Ordinary shares $1 500,000 Retained earnings 250,000 The cost of the...

3. What is at stake for you? What are your values? Are there motives that may be persuading you in one direction instead of another?

7. How might you go about testing these assumptions?

2. How would you define success in this situation? How would other stakeholders define success?