Write SQL statements to perform the following queries: Display the title and pub
ID: 3717009 • Letter: W
Question
Write SQL statements to perform the following queries:
Display the title and publication date for each book in the BOOKS table. Use the column heading “Publication Date” for the Pubdate field.
Display all books published by the publisher assigned Publisher id 9561.
Use a search pattern to find any book title with “N” for the second letter and “R” for the fourth letter. Display each book’s ISBN and title. Sort the list by title in descending order.
Display the ISBN only of all books available in the library.
Display the title and publish date of any book published in 2009. Perform the task of searching for the publish date by using three different methods: a) a range operator, b) a logical operator, and c) a search pattern operation.
Contents of the BOOKS table | isbn | pub_date title | Pub_id | list_price | category id | I Among the Russians 9880 11.2099999 14.9599999 98888 98888 9800 59.99 98888 l 95555 1 99999 199999 l 99999 95555 | 0068959290NULL | 0132149871 2001-82-03 | North Carolina Hiking Trails | 0201385902 | 2010-03-25 | Intro to DB Systems-7th Ed | 0201615711 | 2009-08-07| Network Programming with Perl | 02 5 ADO and Oracle Workbook 1 9561 1 9325 88.00 l 9776 1 39.95 1 9288 1 9325 6.99 265615357 | 2009-03-2 | 8299282519 | 2005-09-02 The tale of the body thief 0312135033 |2011-05-12 | Great Catherine 0345298063 2004-06-09 | Peter the Great : His Life and World 0345438310 | 2008-03-10 | Nicholas and Alexandra 0399501487 | 2000-03-28 | Lord of the F1ies: A Novel 9561 13.56 9080 11.20 9561 14.40 9561 1 6.95Explanation / Answer
(i) SELECT title AS "Title",pub_date AS "Publication Date" FROM BOOKS .
(ii)SELECT DISTINCT title FROM BOOKS WHERE Pub_id is 9561.
(iii) SELECT title FROM BOOKS WHERE title LIKE "_N_R%".
(iv) SELECT isbn,title FROM BOOKS ORDER BY title DESC.
(v) Need more information
(vi)SELECT title,pub_date WHERE pub_date LIKE "2009%".
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.