QL Basic Query 1. Show the first name, last name, city and e-mail of each customer in New Jersey 2. Show all book titles ordered on or after December 31, 1999. [Do not list any title more than once.] 3. Show the title, author name, publisher name, publication year, and number on hand for all books of which we have at least 10 copies on hand, and which were published by Knopf or published after 1985 (or both). Sort the output by the number of copies on hand, with the largest number of books on hand coming first. Books with the same number of copies hand should appear in alphabetical order by title. 4. For each author with any books with a publication year before 1940, give the author's name and the number of such books. Sort the results in order of the number of books, with the largest number of books appearing first. The number of books column should have the heading "number_of_books". 5. Show the number of titles and total number of copies on hand of books that have a retail price less than $20. These results should respectively be labeled "number_of_titles" and "number_of_copies". 6. Show the first name, last name, and number of physical books ordered (labeled "num_ordered") for all customers who have ordered at least 11 physical books. Sort the results alphabetically by last name, with customers having the same last name sorted alphabetically by first name.