Please respond correctly
WWIMPORTERS.BUYINGGROUPS P BUYINGGROUPID NUMBER (10) VARCHAR2 (50 BYTE) *BUYINGGROUPNAME *LASTEDITEDBY NUMBER (10) VALIOFROM DATE VALIDTO DATE PK_BUYINGGROUPS (BUYINGGROUPID) P ORDERID F WWIMPORTERS.ORDERS NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10) DATE DATE VARCHAR2 (20 CHAR) NUMBER (10) DATE NUMBER (10) DATE VARCHAR2 (4000 BYTE) VARCHAR2 (4000 BYTE) VARCHAR2 (4000 BYTE) NUMBER CUSTOMERID *SALESPERSONPERSONID PICKEDBYPERSONID CONTACTPERSONID BACKORDERORDERID * ORDERDATE * EXPECTEDDELIVERYDATE CUSTOMERPURCHASEORDERNUMBER ISUNDERSUPPLYRACKORDERED PICKINGCOMPLETEDWHEN * LASTEDITEDBY * LASTEDITEDWHEN COMMENTS DELIVERYINSTRUCTIONS INTERNAL COMMENTS * CUSTOMERS CUSTOMERID PK ORDERID (ORDERID) ORDERS CUSTOMERS FK (CUSTOMERID WWIMPORTERS.ORDERLINES P ORDERLINEID NUMBER (10) F ORDERID NUMBER (10) STOCKITEMID NUMBER (10) DESCRIPTION VARCHAR2 (100 CHAR) *PACKAGETYPEID NUMBER (10) NUMBER NUMBER (10) QUANTITY UNITPRICE NUMBER (38,2) TAXRATE NUMBER (38,2) PICKEDQUANTITY NUMBER (10) PICKINGCOMPLETEDWHEN DATE LASTEDITEDBY NUMBER (10) LASTEDITEDWHEN DATE *ORDERS_ORDERID NUMBER PK_ORDERLINEID (ORDERLINEID) ORDERLINES ORDERS FK (ORDERID) P CUSTOMERID WWIMPORTERS.CUSTOMERS WWIMPORTERS.CUSTOMERCATEGORIES P CUSTOMERCATEGORYID NUMBER (10) VARCHAR2 (50 BYTE) * CUSTOMERCATEGORYNAME *LASTEDITEDBY NUMBER (10) VALIOFROM DATE * VALIOTO DATE PK_CUSTOMERCATEGORIES (CUSTOMERCATEGORYID) P. CITYID CITYNAME F STATEPROVINCEID LOCATION NUMBER (10) CUSTOMERNAME VARCHAR2 (100 CHARI *BILLTOCUSTOMERID NUMBER (10) CUSTOMERCATEGORYID NUMBER (10) F BUYINGGROUPID NUMBER (10) *PRIMARYCONTACTPERSONID NUMBER (10) ALTERNATECONTACTPERSONID NUMBER (10) * DELIVERYMETHODID NUMBER (10) DELIVERYCITYID NUMBER (10) POSTALCITYID CREDITLIMIT NUMBER (10) NUMBER (382) DATE *ACCOUNTOPENEDDATE STANDARDDISCOUNTPERCENTAGE NUMBER (382) ISSTATEMENTSENT NUMBER (10) *ISONCREDITHOLD NUMBER (10) *PAYMENTDAYS NUMBER (10) PHONENUMBER VARCHAR2 (20 CHAR) * FAXNUMBER DELIVERYRUN VARCHAR2 (20 CHAR) VARCHAR2 (5 CHAR) VARCHAR2 (5 CHAR) RUNPOSITION WEBSITEURL VARCHAR2 (256 CHARI * DELIVERYADDRESSLINE1 VARCHAR2 (60 CHAR) DELIVERYADDRESSLINE? DELIVERYPOSTALCODE DELIVERYLOCATION VARCHAR2(0 CHAR) VARCHAR2(10 CHAR) BLCB * POSTALADDRESSLINE! VARCHAR2 (60 CHAR) VARCHAR2 (60 CHAR) POSTALADORESSLINE2 *POSTALPOSTALCODE *LASTEDITEDDY VARCHAR2 (10 CHAR) NUMBER (10) DATE *VALIOFROM *VALIOTO DATE * CUSTOMERCATEGORIES CUSTOMERCATEGORYID NUMBER * BUYINGGROUPS DUYINGGROUPID NUMBER CITIES_CITYID NUMBER PK CUSTOMERS (CUSTOMERID) CUSTOMERS_CUSTOMERCATEGORIES FK (CUSTOMERCATEGORYID) SFK NYING COME CUSTOMERS BUYINGGROUPS FK (BUYINGGROUPID! CUSTOMERS_CITIES_FK (POSTALCITYID) PK_CUSTOMERS (CUSTOMERID) WWIMPORTERS.CITIES NUMBER (10) VARCHAR2 (50 CHA NUMBER (10) BLOB LATESTRECORDEDPOPULATION NUMBER (38) LASTEDITEDBY NUMBER (10) VARCHAR2 (27 CHA *VALIDFROM *VALIDTO VARCHAR2 (27 CHA STATEPROVINCES STATEPROVINCEID NUMBER CITIES PK (CITYID) CITIES STATEPROVINCES FK (STATEPROVINCEID) WWIMPORTERS.STATEPROVINCES P STATEPROVINCEID * STATEPROVINCECODE STATEPROVINCENAME COUNTRYID *SALESTERRITORY BORDER LATESTRECORDEDPOPULATION * LASTEDITEDBY VALIDFROM VALIDARO VALIDTO STATEPROVINCES PK (STATEPROVINCED) NUMBER (10) VARCHAR2 (6 CHAR) VARCHAR2 (50 CHAR) NUMBER (10) VARCHAR2 (50 CHAR) BLOB NUMBER (38) NUMBER (10) VARCHAR2 (27 CHAR) VARCHAR2 (27 CHAR) VARCHAR2 (270 1. What was the total sales overall and by category for each year to our non-buying group customers? (Hint: Buying Group Customers have a buying group ID) I also need sales broken down for each month. Be sure to include the dollar amount sold in your summary. 2. I will need a ranking of the categories for the past five months in total. Then, I need a breakdown for each of the past five months. After this analysis, I want your assessment of our overall top two categories. Be sure to include how you determined the top two. 3. I need a similar analysis for customers in the top two categories. I need a ranked list of the top five customers in the top categories for each of the last five months, use the dollar amount purchased per month to rank customers in each category. I also need to know which customers were in the top five for more than one month (how often and what rank). Specifically, I would like to know which customers, if any, were in the top 5 for all five months for either category. 4. Most importantly, since we do not know what else the committee may want to know, please create a flexible tool that can provide me the ability to look at customer and category sales information in other ways (you can assume that I am pretty proficient in using excel pivot tables and should include such a tool). WWIMPORTERS.BUYINGGROUPS P BUYINGGROUPID NUMBER (10) VARCHAR2 (50 BYTE) *BUYINGGROUPNAME *LASTEDITEDBY NUMBER (10) VALIOFROM DATE VALIDTO DATE PK_BUYINGGROUPS (BUYINGGROUPID) P ORDERID F WWIMPORTERS.ORDERS NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10) DATE DATE VARCHAR2 (20 CHAR) NUMBER (10) DATE NUMBER (10) DATE VARCHAR2 (4000 BYTE) VARCHAR2 (4000 BYTE) VARCHAR2 (4000 BYTE) NUMBER CUSTOMERID *SALESPERSONPERSONID PICKEDBYPERSONID CONTACTPERSONID BACKORDERORDERID * ORDERDATE * EXPECTEDDELIVERYDATE CUSTOMERPURCHASEORDERNUMBER ISUNDERSUPPLYRACKORDERED PICKINGCOMPLETEDWHEN * LASTEDITEDBY * LASTEDITEDWHEN COMMENTS DELIVERYINSTRUCTIONS INTERNAL COMMENTS * CUSTOMERS CUSTOMERID PK ORDERID (ORDERID) ORDERS CUSTOMERS FK (CUSTOMERID WWIMPORTERS.ORDERLINES P ORDERLINEID NUMBER (10) F ORDERID NUMBER (10) STOCKITEMID NUMBER (10) DESCRIPTION VARCHAR2 (100 CHAR) *PACKAGETYPEID NUMBER (10) NUMBER NUMBER (10) QUANTITY UNITPRICE NUMBER (38,2) TAXRATE NUMBER (38,2) PICKEDQUANTITY NUMBER (10) PICKINGCOMPLETEDWHEN DATE LASTEDITEDBY NUMBER (10) LASTEDITEDWHEN DATE *ORDERS_ORDERID NUMBER PK_ORDERLINEID (ORDERLINEID) ORDERLINES ORDERS FK (ORDERID) P CUSTOMERID WWIMPORTERS.CUSTOMERS WWIMPORTERS.CUSTOMERCATEGORIES P CUSTOMERCATEGORYID NUMBER (10) VARCHAR2 (50 BYTE) * CUSTOMERCATEGORYNAME *LASTEDITEDBY NUMBER (10) VALIOFROM DATE * VALIOTO DATE PK_CUSTOMERCATEGORIES (CUSTOMERCATEGORYID) P. CITYID CITYNAME F STATEPROVINCEID LOCATION NUMBER (10) CUSTOMERNAME VARCHAR2 (100 CHARI *BILLTOCUSTOMERID NUMBER (10) CUSTOMERCATEGORYID NUMBER (10) F BUYINGGROUPID NUMBER (10) *PRIMARYCONTACTPERSONID NUMBER (10) ALTERNATECONTACTPERSONID NUMBER (10) * DELIVERYMETHODID NUMBER (10) DELIVERYCITYID NUMBER (10) POSTALCITYID CREDITLIMIT NUMBER (10) NUMBER (382) DATE *ACCOUNTOPENEDDATE STANDARDDISCOUNTPERCENTAGE NUMBER (382) ISSTATEMENTSENT NUMBER (10) *ISONCREDITHOLD NUMBER (10) *PAYMENTDAYS NUMBER (10) PHONENUMBER VARCHAR2 (20 CHAR) * FAXNUMBER DELIVERYRUN VARCHAR2 (20 CHAR) VARCHAR2 (5 CHAR) VARCHAR2 (5 CHAR) RUNPOSITION WEBSITEURL VARCHAR2 (256 CHARI * DELIVERYADDRESSLINE1 VARCHAR2 (60 CHAR) DELIVERYADDRESSLINE? DELIVERYPOSTALCODE DELIVERYLOCATION VARCHAR2(0 CHAR) VARCHAR2(10 CHAR) BLCB * POSTALADDRESSLINE! VARCHAR2 (60 CHAR) VARCHAR2 (60 CHAR) POSTALADORESSLINE2 *POSTALPOSTALCODE *LASTEDITEDDY VARCHAR2 (10 CHAR) NUMBER (10) DATE *VALIOFROM *VALIOTO DATE * CUSTOMERCATEGORIES CUSTOMERCATEGORYID NUMBER * BUYINGGROUPS DUYINGGROUPID NUMBER CITIES_CITYID NUMBER PK CUSTOMERS (CUSTOMERID) CUSTOMERS_CUSTOMERCATEGORIES FK (CUSTOMERCATEGORYID) SFK NYING COME CUSTOMERS BUYINGGROUPS FK (BUYINGGROUPID! CUSTOMERS_CITIES_FK (POSTALCITYID) PK_CUSTOMERS (CUSTOMERID) WWIMPORTERS.CITIES NUMBER (10) VARCHAR2 (50 CHA NUMBER (10) BLOB LATESTRECORDEDPOPULATION NUMBER (38) LASTEDITEDBY NUMBER (10) VARCHAR2 (27 CHA *VALIDFROM *VALIDTO VARCHAR2 (27 CHA STATEPROVINCES STATEPROVINCEID NUMBER CITIES PK (CITYID) CITIES STATEPROVINCES FK (STATEPROVINCEID) WWIMPORTERS.STATEPROVINCES P STATEPROVINCEID * STATEPROVINCECODE STATEPROVINCENAME COUNTRYID *SALESTERRITORY BORDER LATESTRECORDEDPOPULATION * LASTEDITEDBY VALIDFROM VALIDARO VALIDTO STATEPROVINCES PK (STATEPROVINCED) NUMBER (10) VARCHAR2 (6 CHAR) VARCHAR2 (50 CHAR) NUMBER (10) VARCHAR2 (50 CHAR) BLOB NUMBER (38) NUMBER (10) VARCHAR2 (27 CHAR) VARCHAR2 (27 CHAR) VARCHAR2 (270 1. What was the total sales overall and by category for each year to our non-buying group customers? (Hint: Buying Group Customers have a buying group ID) I also need sales broken down for each month. Be sure to include the dollar amount sold in your summary. 2. I will need a ranking of the categories for the past five months in total. Then, I need a breakdown for each of the past five months. After this analysis, I want your assessment of our overall top two categories. Be sure to include how you determined the top two. 3. I need a similar analysis for customers in the top two categories. I need a ranked list of the top five customers in the top categories for each of the last five months, use the dollar amount purchased per month to rank customers in each category. I also need to know which customers were in the top five for more than one month (how often and what rank). Specifically, I would like to know which customers, if any, were in the top 5 for all five months for either category. 4. Most importantly, since we do not know what else the committee may want to know, please create a flexible tool that can provide me the ability to look at customer and category sales information in other ways (you can assume that I am pretty proficient in using excel pivot tables and should include such a tool)
