Question 1

(exercise 1.11) For Query: How many different products were bought on order 1001? In step 3, what should you write

Question 1 options:

	3
	count(P#)
	sum(P#)
	P#

Question 2

For Query: Display the o# of orders where there is any "short ship". In step 2, what should you write?

Question 2 options:

	shot ship
	Count(o#)
	OrdQty-ShippedQty
	OrdQty>ShippedQty

Question 3

(exercise 1.11)For Query: Display the name of the customers who experienced short ship. In step 1, which tables should you choose?

Question 3 options:

	Customers,Orders, OrderDetails
	Customers,OrderDetails
	Customers,Orders,OrderDetails,Products
	Customers

Question 4

(exercise 1.11)For Query: How many units in total are ordered in order 1001? In step 3, what should you write

Question 4 options:

	sum(OrdQty)
	count(OrdQty)
	ordQty
	Max(OrdQty)

Question 5

(exercise 1.11)For Query: What is the total shipped amount of O#1001? In step 3, what should you write

Question 5 options:

	sum(OrdQty*UnitPrice)
	sum(ShippedQty)*sum(UnitPrice)
	ShippedQty*UnitPrice
	sum(ShippedQty*UnitPrice)

Question 6

(exercise 1.11)For Query: How many units of product 20100093 are purchased by customer 0023? In step 3, what should you write?

Question 6 options:

	sum(OrdQty)
	count(20100093)
	count(OrdQty)
	sum(20100093)

Question 7

(exercise 1.11)For Query: What is the total shipped amount customer 0023 paid for product 20100093? In step 3, what should you write?

Question 7 options:

	sum(ShippedQty*UnitPrice)
	count(ShippedQty*UnitPrice)
	sum(ShippedQty)
	sum(20100093*0023)

Question 8

(exercise 1.11)For Query: What is the total order amount of O#1001? In step 3, what should you write

Question 8 options:

	ordQty*UnitPrice
	sum(OrdQty)*sum(UnitPrice)
	sum(OrdQty)
	sum(OrdQty*UnitPrice)

Question 9

(exercise 1.11)For Query: How many total units are purchased by Customer 0023? In step 1, which tables should you choose

Question 9 options:

	OrderDetails,Customers
	OrderDetails
	OrderDetails,Customers,Orders
	OrderDetails,Orders

Orders O# ODate 1001 5/1/2005 1002 5/3/2005 1003 5/3/2005 1004 5/6/2005 Cust# 0023 0023 0018 0021 Status Customers Cust# CustName 0018 Sony 0019 Disney 0021 MGM 0023 Universal Region NW SW SW NE AcctClass A B A Order Details O# P# Products P# PName Ord Qty 10 8 5 10 21 25 13 4 2 20100090 20100091 20100092 20100093 Unit Shipped Price Qty 8.99 12.99 8 9.52 5 12.99 10 9.52 20 12.99 25 12.49 13 9.52 4 8.99 2 1001 1001 1001 1002 1002 1003 1004 1004 1004 Lord of the Ring American Beauty The Mask Animal Kingdom Unit Price 8.99 11.99 12.49 9.52 20100090 20100091 20100093 20100092 20100093 20100092 20100092 20100093 20100090