Sql Northwind DB
From: arva (anonymous_at_discussions.microsoft.com)
Date: 09/06/04
- Next message: Hugo Kornelis: "Re: Sql Northwind DB"
- Previous message: VintageRad: "Disable SQL"
- Next in thread: Hugo Kornelis: "Re: Sql Northwind DB"
- Reply: Hugo Kornelis: "Re: Sql Northwind DB"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 6 Sep 2004 14:47:34 -0700
Please send me the answers to the following questions.
This is very urgent,use the northwind Database in Sql
server to build your query.
1.Provide a SQL statement and sample result set that will
list all Customers within the CA state.
2.Provide a SQL statement and sample result set that will
count the total orders for all Customers within the CA
state.
3.Provide a SQL statement and sample result set that will
count orders for all Customers within the CA state during
the 2002 calendar year sorted by Customer name.
4.Provide a SQL statement and sample result set that will
list all Customers within the CA state that have placed 10
or more orders during the 2002 calendar year.
5.Customer Perks Program. Management would like to setup
a Platinum Buyer Club for all customers who have
consistently placed 10 or more orders each year for the
previous 10 years. Provide a SQL statement and sample
result set that will list the qualifying Customers, the
average placed orders during a year, and the total number
of orders placed each year. This SQL statement should
bring back one record per Customer for the Program.
6.Invoice for an Order. With each order shipped, there is
an invoice to the customer. Provide a SQL statement and
sample result set that provides the following information:
a. Shipping information (Shipping Name, Address,
City, State, Zip, Country)
b. Customer information (Customer Name, Address,
City, State, Zip, Country)
c. Sales Person (Employee who took the order)
d. Order Information (Order Number, Order Date,
Required Date, Shipped Date, Shipper)
e. Order Details (Product Category, Product, Unit
Price, Quantity, Discount, Total Price)
7.Product Analysis for Marketing. Marketing department
would like to advertise new products to customers who
purchase similar category of products during the 2002
year. Provide a SQL statement and sample result set that
will list the product categories and the total units
ordered during the 2002 calendar year by Customer. If
there were no products ordered within the category,
display a zero.
8.Goodwill Gifts for Suppliers and Shippers. Management
would like to purchase gifts for suppliers and shippers as
goodwill to continue a strong working relationship.
Provide a single SQL statement and a sample result set
that will list suppliers, a list of products supplied, and
their total orders using those products, and list
shippers, order ship state, and the total orders shipped
all during the 2002 calendar year.
9.Promotions / Order Trend Analysis. Marketing would like
to provide a promotions for products that may not ordered
during particular months. Provide a SQL statement and
sample result set that will provide a list of products and
total units ordered by month broken down by product
category.
10.Employee Bonuses. Employees are given a bonus each
year for the total orders and total order purchase price.
Provide a SQL statement and sample result set that lists
each employee, the total order counts, and total order
purchase price for the past 2 years broken down by year.
Include each active employee regardless of those who have
not been associated with orders taken over the past 2
years.
Thanx
Arva
- Next message: Hugo Kornelis: "Re: Sql Northwind DB"
- Previous message: VintageRad: "Disable SQL"
- Next in thread: Hugo Kornelis: "Re: Sql Northwind DB"
- Reply: Hugo Kornelis: "Re: Sql Northwind DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
