Assignment: 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)
1. What were the genders for top 10 customers? (Use: Rank)
2. Which products are most profitable for a specific time period? (Use: Grouping Sets)
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.