UA_SAMSCLUB Tables
item_desc:Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Color_Desc, Size_Desc, Status_Code, Fineline, UPC, UPC_Desc, Create_Date, Effective_Date, Obsolete_Date, Vendor_Nbr, Vendor_Name, Vendor_Stock_Nbr, VNPK_Qty, VNPK_Cubic_Ft, WHPK_Qty, Last_Change_Date, Last_Change_Time, Expiration_Date, Status_Chg_Date, Mfg_Nbr, Activity_CD, Brand_Name
item_scan:Visit_Nbr, Store_Nbr, Item_Nbr, Item_Quantity, Total_Scan_Amount, transaction_Date, Unit_Cost_Amount, Unit_Retail_Amount, Tax_Collect_Code
member_index:MEMBERSHIP_NBR, ZIP_CODE, SIC, MEMBER_TYPE, MEMBER_STATUS_CD, ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, ELITE_STAT_CODE, BUS_CR_TYP_STAT_CD, SECONDARY_CARD_CNT, QUALIFY_ORG_CODE, CMPLMNTRY_CARD_CNT, LAST_RENEWAL_DATE
store_information:Store_Nbr, Store_Name, Align_Sub_Division_Nbr, Region_Nbr, District_Nbr, Open_Date, Store_Type, Street_Addr, City, State, ZIP_Code, Phone_Nbr, Manager_Name, Open_Sunday_Flag, Geographic_Zone, Apparel_Zone, SizeClass, SalesClass, Store_Code, Delivery_Type, Mdse_Major_Zone, Mdse_Sub_Zone
store_visits:Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt, Total_Visit_Amt, Transaction_Date, Transaction_Time, Refund_Code, Upcharge_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, Operator_nbr
SUB_CATEGORY_DESC:Category_Nbr,Sub_Category_Nbr,Sub_Category_Desc,Buyer_ID
WAREHOUSE:Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt Total_Visit_Amt, Transaction_Date, Transaction_Time, Refund_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, MEM_ZIP, MEMBER_TYPE, MEMBER_STATUS_CD, ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, Store_Name, STO_ZIP, Item_Quantity, Total_Scan_Amount, Unit_Cost_Amount, Unit_Retail_Amount, Tax_Collect_Code, Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Create_Date, Effective_Date, Sub_category_desc
问题：
1. Find the average number of stores a member visits each month, and the average amount per store per month that a member spends.
2. Find items among those with 20 lowest profits purchsed from a vendor and sold between June 1st and August 30th, 2000.Profit is calculated as (unit_retail_amount- unit_cost_amount)* item quantity.
3.Find the number of visits to stores that are open on sundays, and store_code is T and store_type is S.
4.Perform a rollup sales revenues for sub_desc contains FRIDGES, primary_desc or secondary_desc contains COMPACT. Sub_totals should be provide.
5.Perform a cube type subtotal on revenues with elite status_code, city of store, and primary or secondary description containing "COMPACT".
item_desc:Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Color_Desc, Size_Desc, Status_Code, Fineline, UPC, UPC_Desc, Create_Date, Effective_Date, Obsolete_Date, Vendor_Nbr, Vendor_Name, Vendor_Stock_Nbr, VNPK_Qty, VNPK_Cubic_Ft, WHPK_Qty, Last_Change_Date, Last_Change_Time, Expiration_Date, Status_Chg_Date, Mfg_Nbr, Activity_CD, Brand_Name
item_scan:Visit_Nbr, Store_Nbr, Item_Nbr, Item_Quantity, Total_Scan_Amount, transaction_Date, Unit_Cost_Amount, Unit_Retail_Amount, Tax_Collect_Code
member_index:MEMBERSHIP_NBR, ZIP_CODE, SIC, MEMBER_TYPE, MEMBER_STATUS_CD, ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, ELITE_STAT_CODE, BUS_CR_TYP_STAT_CD, SECONDARY_CARD_CNT, QUALIFY_ORG_CODE, CMPLMNTRY_CARD_CNT, LAST_RENEWAL_DATE
store_information:Store_Nbr, Store_Name, Align_Sub_Division_Nbr, Region_Nbr, District_Nbr, Open_Date, Store_Type, Street_Addr, City, State, ZIP_Code, Phone_Nbr, Manager_Name, Open_Sunday_Flag, Geographic_Zone, Apparel_Zone, SizeClass, SalesClass, Store_Code, Delivery_Type, Mdse_Major_Zone, Mdse_Sub_Zone
store_visits:Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt, Total_Visit_Amt, Transaction_Date, Transaction_Time, Refund_Code, Upcharge_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, Operator_nbr
SUB_CATEGORY_DESC:Category_Nbr,Sub_Category_Nbr,Sub_Category_Desc,Buyer_ID
WAREHOUSE:Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt Total_Visit_Amt, Transaction_Date, Transaction_Time, Refund_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, MEM_ZIP, MEMBER_TYPE, MEMBER_STATUS_CD, ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, Store_Name, STO_ZIP, Item_Quantity, Total_Scan_Amount, Unit_Cost_Amount, Unit_Retail_Amount, Tax_Collect_Code, Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Create_Date, Effective_Date, Sub_category_desc
问题：
1. Find the average number of stores a member visits each month, and the average amount per store per month that a member spends.
2. Find items among those with 20 lowest profits purchsed from a vendor and sold between June 1st and August 30th, 2000.Profit is calculated as (unit_retail_amount- unit_cost_amount)* item quantity.
3.Find the number of visits to stores that are open on sundays, and store_code is T and store_type is S.
4.Perform a rollup sales revenues for sub_desc contains FRIDGES, primary_desc or secondary_desc contains COMPACT. Sub_totals should be provide.
5.Perform a cube type subtotal on revenues with elite status_code, city of store, and primary or secondary description containing "COMPACT".
item_desc:Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Color_Desc, Size_Desc, Status_Code, Fineline, UPC, UPC_Desc, Create_Date, Effective_Date, Obsolete_Date, Vendor_Nbr, Vendor_Name, Vendor_Stock_Nbr, VNPK_Qty, VNPK_Cubic_Ft, WHPK_Qty, Last_Change_Date, Last_Change_Time, Expiration_Date, Status_Chg_Date, Mfg_Nbr, Activity_CD, Brand_Name
item_scan:Visit_Nbr, Store_Nbr, Item_Nbr, Item_Quantity, Total_Scan_Amount, transaction_Date, Unit_Cost_Amount, Unit_Retail_Amount, Tax_Collect_Code
member_index:MEMBERSHIP_NBR, ZIP_CODE, SIC, MEMBER_TYPE, MEMBER_STATUS_CD, ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, ELITE_STAT_CODE, BUS_CR_TYP_STAT_CD, SECONDARY_CARD_CNT, QUALIFY_ORG_CODE, CMPLMNTRY_CARD_CNT, LAST_RENEWAL_DATE
store_information:Store_Nbr, Store_Name, Align_Sub_Division_Nbr, Region_Nbr, District_Nbr, Open_Date, Store_Type, Street_Addr, City, State, ZIP_Code, Phone_Nbr, Manager_Name, Open_Sunday_Flag, Geographic_Zone, Apparel_Zone, SizeClass, SalesClass, Store_Code, Delivery_Type, Mdse_Major_Zone, Mdse_Sub_Zone
store_visits:Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt, Total_Visit_Amt, Transaction_Date, Transaction_Time, Refund_Code, Upcharge_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, Operator_nbr
SUB_CATEGORY_DESC:Category_Nbr,Sub_Category_Nbr,Sub_Category_Desc,Buyer_ID
WAREHOUSE:Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt Total_Visit_Amt, Transaction_Date, Transaction_Time, Refund_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, MEM_ZIP, MEMBER_TYPE, MEMBER_STATUS_CD, ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, Store_Name, STO_ZIP, Item_Quantity, Total_Scan_Amount, Unit_Cost_Amount, Unit_Retail_Amount, Tax_Collect_Code, Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Create_Date, Effective_Date, Sub_category_desc
问题：
1. Find the average number of stores a member visits each month, and the average amount per store per month that a member spends.
2. Find items among those with 20 lowest profits purchsed from a vendor and sold between June 1st and August 30th, 2000.Profit is calculated as (unit_retail_amount- unit_cost_amount)* item quantity.
3.Find the number of visits to stores that are open on sundays, and store_code is T and store_type is S.
4.Perform a rollup sales revenues for sub_desc contains FRIDGES, primary_desc or secondary_desc contains COMPACT. Sub_totals should be provide.
5.Perform a cube type subtotal on revenues with elite status_code, city of store, and primary or secondary description containing "COMPACT". UA_SAMCLUB 的数据库表格item_desc（属性、项目、因素）表：
Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Color_Desc, Size_Desc, Status_Code,
Fineline, UPC, UPC_Desc, Create_Date, Effective_Date, Obsolete_Date, Vendor_Nbr, Vendor_Name, Vendor_Stock_Nbr, VNPK_Qty, VNPK_Cubic_Ft, WHPK_Qty,
Last_Change_Date, Last_Change_Time, Expiration_Date, Status_Chg_Date, Mfg_Nbr, Activity_CD, Brand_Name item_scan（扫描、查询）表：
Visit_Nbr, Store_Nbr, Item_Nbr, Item_Quantity, Total_Scan_Amount, transaction_Date, Unit_Cost_Amount, Unit_Retail_Amount, Tax_Collect_Codemember_index（会员索引）表：
MEMBERSHIP_NBR, ZIP_CODE, SIC, MEMBER_TYPE, MEMBER_STATUS_CD, ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, ELITE_STAT_CODE, BUS_CR_TYP_STAT_CD,
SECONDARY_CARD_CNT, QUALIFY_ORG_CODE, CMPLMNTRY_CARD_CNT, LAST_RENEWAL_DATE store_information（库存信息）表：
Store_Nbr, Store_Name, Align_Sub_Division_Nbr, Region_Nbr, District_Nbr, Open_Date, Store_Type, Street_Addr, City, State, ZIP_Code, Phone_Nbr,
Manager_Name, Open_Sunday_Flag, Geographic_Zone, Apparel_Zone, SizeClass, SalesClass, Store_Code, Delivery_Type, Mdse_Major_Zone, Mdse_Sub_Zonestore_visits:（库存访问）表：
Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt, Total_Visit_Amt,
Transaction_Date, Transaction_Time, Refund_Code, Upcharge_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, Operator_nbr SUB_CATEGORY_DESC:（子类）表：
Category_Nbr,Sub_Category_Nbr,Sub_Category_Desc,Buyer_ID WAREHOUSE:（可能是数据仓库表，不确认）
Visit_Nbr, Store_Nbr, Register_Nbr, Card_Holder_Nbr, Membership_Nbr, Member_Code, Tender_Type, Tender_Amt, Sales_Tax_Amt Total_Visit_Amt,
Transaction_Date, Transaction_Time, Refund_Code, Tot_Unit_Cost, Tot_Unique_Itm_Cnt, Tot_Scan_Cnt, MEM_ZIP, MEMBER_TYPE, MEMBER_STATUS_CD,
ISSUING_CLUB_NBR, RENEWAL_DATE, JOIN_DATE, Store_Name, STO_ZIP, Item_Quantity, Total_Scan_Amount, Unit_Cost_Amount, Unit_Retail_Amount,
Tax_Collect_Code, Item_Nbr, Category_Nbr, Sub_Category_Nbr, Primary_Desc, Secondary_Desc, Create_Date, Effective_Date, Sub_category_desc 问题：
1. Find the average number of stores a member visits each month, and the average amount per store per month that a member spends.
查询每个用户每月访问库存的平均数和月消费的平均数。
2. Find items among those with 20 lowest profits purchsed from a vendor and sold between June 1st and August 30th, 2000.Profit is calculated as (unit_retail_amount- unit_cost_amount)* item quantity.
查询从2000年6月1日到8月30日的售出最低的20件商品及供应商信息，并计算：（零售 - 成本） * 数量。
3.Find the number of visits to stores that are open on sundays, and store_code is T and store_type is S.
查询周日访问库存代码为“T”，且库存状态为“S”的成员
4.Perform a rollup sales revenues for sub_desc contains FRIDGES, primary_desc or secondary_desc contains COMPACT. Sub_totals should be provide.
5.Perform a cube type subtotal on revenues with elite status_code, city of store, and primary or secondary description containing "COMPACT". 这是一个在线购物网站的数据库。
问题好像是个作业。
时间有限，写出来没检查。