Practice Questions

Use Lesson 3 SQL Script (Orders_at_TheLiterarySociety.sql) for the exercises below.

Q1. Write an SQL statement that display titles and the author’s last names. (28 rows)




Q2. Write an SQL statement that display publishers and books with quantity available more than 10. (4 rows)





Q3. Write an SQL statement that display book titles for the authors whose last name starts with letter G. (6 rows)




Q4. Write an SQL statement that display quantity ordered and school which ordered psychology books. (3 rows)



Last modified: Wednesday, 1 November 2017, 4:33 PM