patient paid the most amount of money directly for a single visit in April
all of the drugs prescribed on June 24, 2013.
the employees who treated patients on July 4, 2013; without duplicates.
Rolling Thunder Bicycles
List customers (name, phone) who bought race bikes in 2012 with a frame size
greater than 60 cm.
the component product number and weight that are in the SRAM Red 2012
full suspension bikes sold in 20
A local family has a large garden and regularly sells produce at the local
Farmers Market. Up to now the group has just picked items and sold them
each weekbasically tracking just the amount of money received. Now the
family wants to track sales by typ
A7: Ch.4 #26, 28, 29, 30, 31
26) List customers (name, phone) who bought race bikes in 2012 with a frame size greater than
SELECT [FirstName] & " " & [LastName] AS FullName, Customer.Phone
FROM Customer INNER JOIN Bicycle ON Customer.CustomerID = B
18) Which employee has been #1 in monthly sales value for the most number of months in 20102011?
SELECT Format([OrderDate],"yyyy-mm") AS YearMonth, Bicycle.EmployeeID,
Sum(Bicycle.SalePrice) AS SumOfSalePrice
WHERE (Bicycle.OrderDate) Betw
1) Which suppliers did not deliver any items in September?
SELECT Supplier.SupplierID, Supplier.Name, Supplier.ContactName
WHERE (Supplier.SupplierID) Not In (SELECT MerchandiseOrder.SupplierID
A6: Ch.4 Ex: 2, 3, 15, 18, 19
2) What is the largest quantity of items ever ordered/purchased by the store at one
SELECT TOP 1 OrderItem.ItemID, OrderItem.Quantity, Merchandise.Description
FROM Merchandise INNER JOIN OrderItem ON Merchandise.ItemID
1. Briefly describe how you would protect a computer system from the following problems.
List steps you will take before the event and after the event has occurred.
a. Your local electricity provider expanded into wind and solar power and no
SELECT Customer.LastName, Customer.Phone
FROM City RIGHT JOIN (Customer INNER JOIN Bicycle ON Customer.CustomerID =
Bicycle.CustomerID) ON City.CityID = Customer.CityID
WHERE (Bicycle.OrderDate) Between #1/1/2001# And #12/31/2001#) AND
Rolling Thunder Database
SELECT Component.Year, Avg(Component.Weight) AS AvgOfWeight
WHERE (Component.Road)="road") AND (Component.Category)="Rear derailleur")
GROUP BY Component.Year;
SELECT Bicycle.SaleState, Coun
Sum of Value