Www1.lasalle.edu



|Name(s): |March, 31 2010 |

Perform the following queries for the Pubs database. Paste the SQL below the question.

[pic]

1. Make a list of authors and their book titles. Alphabetize the list first on author last name, then author first name, then on title. (25 records, first author is Bennet.)

2. Make a list of authors followed by the number of books they have written. Include any author even if he/she has not yet written a book. (23 records)

3. Make a list of book titles followed by the number of authors. Include a title even if it has no author. (18 records)

4. Make a list of the bookstores, the title of the books that have been sold to each, and the quantity of each. (21 records)

5. List the bookstores and the total number of book sold to each. Sort by the number of books with the biggest number first. (6 records, Doc-U-Mat was first)

6. List the book titles and the total number sold. List by best-selling first. (16 records, Is Anger the Enemy was first)

7. List the authors and the total number of books sold by that author. List by the best-selling first. (19 records, Ringer first)

8. Make a list of publishers and their employees alphabetize first on publisher then on employee. (43 records, Lucerne Publishing first)

9. Make a list that groups the employees according to their job description. (43 records, Acquisition Manager first)

10. Make a query that yields the top two publishers based on the number of books they publish. (Binnet & Hardley, Algodata Infosystems)

11. Make a list that includes both author and employee names alphabetically on last name. (66 records, Accorti is first)

12. Make a list of employees hired in 1990. List alphabetically. (8 records Afonso)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download