sql · beginner · ~3h
Library queries
Write SQL that answers: which books are on loan, which author has the most titles, which titles were published after 2015.
Requirements
- Use JOIN, not nested guesswork
- Alias columns with readable names
- Order results deterministically
Skills: SQL fundamentals
Starter
queries.sql
sql · sandboxed in your browser
Output
Run to see output.
Hints
- GROUP BY author, COUNT(*) as titles.