This query lists a set of attributes of the products, such as brand, quantity, price, coupon used, and so on bought by a specific category of customers during a specific time period. Query B This query summarizes the price of the Internet-based purchases of a specific set of products by customers in a specific group of geographic areas during a specific time period. Query C This query collects the information of returned items in several fixed length time periods for all stores. Query D This query selects the top items in each quarter of a specific year belonging to a specific set of categories. Query E This query computes the total revenue from a specific set of products, and categorizes the revenue in $50 segments. Query F This query summarizes the monthly sales achievement made by a manager on a specific set of products. Query G This query identifies customers who have a strongly preferred way of shopping. Query H This query obtains the sale records of a specific store in each half hour period. Query I This query shows the per-month sale record for the best-selling products in specific categories. Query J This query gets the sale record of a specific store in a specific time slot where the density of stores in the same area reaches a given level. K This query selects the record of top warehouses where the ship date and sale date are within several fixed-length time periods in a specific year.
This query lists a set of attributes of the products, such as brand, quantity, price, coupon used, and so on bought by a specific category of customers during a specific time period. Query B This query summarizes the price of the Internet-based purchases of a specific set of products by customers in a specific group of geographic areas during a specific time period. Query C This query collects the information of returned items in several fixed length time periods for all stores. Query D This query selects the top items in each quarter of a specific year belonging to a specific set of categories. Query E This query computes the total revenue from a specific set of products, and categorizes the revenue in $50 segments. Query F This query summarizes the monthly sales achievement made by a manager on a specific set of products. Query G This query identifies customers who have a strongly preferred way of shopping. Query H This query obtains the sale records of a specific store in each half hour period. Query I This query shows the per-month sale record for the best-selling products in specific categories. Query J This query gets the sale record of a specific store in a specific time slot where the density of stores in the same area reaches a given level. K This query selects the record of top warehouses where the ship date and sale date are within several fixed-length time periods in a specific year.
StarJoin_SQL2008_R2.docx