Database Developments & SQL Queries

Check the file: Questions.pdf

• Questions.pdf

Q1
SELECT BOOKS.BTitle, BOOKS.TotalSales
FROM AUTHORS, BOOKS
WHERE (((BOOKS.TotalSales)>10000))
ORDER BY BOOKS.BTitle DESC;

Q2
SELECT AUTHORS.AuName, AUTHORS.City, AUTHORS.State, AUTHORS.Country, AUTHORS.BirthDate
FROM AUTHORS
WHERE (((AUTHORS.Country)="Canada"))
ORDER BY AUTHORS.BirthDate DESC;

Q3
SELECT BOOKS.BookID, BOOKS.BTitle, BOOKS.TotalSales, ORDERS.Price, [BOOKS]![TotalSales]*[ORDERS]![Price] AS [Revenue $], ORDERS.ODate, Count(ORDERS.Shipper) AS CountOfShipper
FROM BOOKS INNER JOIN ORDERS ON BOOKS.BookID = ORDERS.BookID
GROUP BY BOOKS.BookID, BOOKS.BTitle, BOOKS.TotalSales, ORDERS.Price, [BOOKS]![TotalSales]*[ORDERS]![Price], ORDERS.ODate
HAVING ((([BOOKS]![TotalSales]*[ORDERS]![Price])>10000) AND ((ORDERS.ODate)>=#1/1/2012#));...

This is only a preview of the solution. Please use the purchase button to see the entire solution