What were the genders for top ten customers

Assignment Help Management Information Sys

Reference no: EM132250191

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)

Reference no: EM132250191

Questions Cloud

How an effective leader fosters and supports change : Consider how an effective leader fosters and supports change. Think of two characteristics an effective leader would need to foster and support change.

Discuss the importance of development and integration : Discuss the importance of development and integration of information systems in project management.

What is the maximum authorized router inventory : What is the maximum authorized router inventory? What is the maximum authorized router inventory under new conditions?

Define evaluation strategies that online instructors use : From the first e-Activity, the increasing Web-based content has exerted more pressure on policymakers and legislators in the U.S. Congress to enact new.

What were the genders for top ten customers : What were the genders for top 10 customers? Which products are most profitable for a specific time period?

Warranties in product management : Describe the role of packaging, labeling, and warranties in product management.

Maximum authorized inventory under new conditions : What is the maximum authorized inventory? What is the maximum authorized inventory under new conditions?

Explain the purpose of the recovery audit contractor : Explain the history and purpose of the Recovery Audit Contractor (RAC) demonstration project, as well as the process of the RAC.

Analyze the marketing framework through a situation analysis : Analyze the marketing framework through a situation analysis. Evaluate target customer segments and positioning products within these segments.

User Account

All Pages