Structured Query Language (SQL)

Running head: STRUCTURED QUERY LANGUAGE (SQL)
Structured Query Language (SQL)
Name of the Student
Name of the University

1STRUCTURED QUERY LANGUAGE (SQL)
Table of Contents
SQL Statements:..............................................................................................................................2
Rationale:.........................................................................................................................................4
Reflection:........................................................................................................................................4
Bibliography:...................................................................................................................................5

2STRUCTURED QUERY LANGUAGE (SQL)
SQL Statements:
Number of books published by New Moon Books in 2010:
SELECT Count(Books.title_id) AS CountOftitle_id, Publishers.pub_name FROM
Publishers LEFT JOIN Books ON Publishers.pub_id = Books.pub_id HERE
(((Books.pubdate)>=#1/1/2010# And (Books.pubdate)<=#12/31/2010#)) GROUP BY
Publishers.pub_name HAVING (((Publishers.pub_name)="New Moon Books"));
What was the highest royalty paid for a book?
SELECT Max(Books.royalty) AS MaxOfroyalty FROM Books;
Identify the five authors that made the highest royalty.
SELECT TOP 5 B.title, B.royalty FROM Books AS B WHERE (((B.royalty) In (Select
TOP 5 Bo.royalty From Books Bo Where Bo.title_id = B.title_id Order By B.royalty DESC)))
ORDER BY B.royalty DESC;
Identify who were the top 10 titles by sales.
SELECT TOP 5 B.title, B.ytd_sales FROM Books AS B WHERE (((B.ytd_sales) In
(Select TOP 10 Bo.ytd_sales From Books Bo Where Bo.title_id = B.title_id Order By
B.ytd_sales DESC ))) ORDER BY B.ytd_sales DESC;