Advertisement
Guest User

Untitled

a guest
Jan 21st, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.16 KB | None | 0 0
  1. SELECT Genres.genre, MIN(publication_year) AS oldest FROM Genres
  2. RIGHT JOIN Books ON Genres.id = Books.genre_id
  3. GROUP BY Genres.genre
  4. ORDER BY Genres.genre;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement