Challenge: Highlight New Arrivals
Your library recently received a shipment of new books published after 2015. You need to create a list of all books that are published later than 2015 to showcase them in the "New Arrivals" section.
Tarea
Swipe to start coding
Write a query which lists the title, author and genre of the books that have their publication year greater than 2015.
The books table includes these columns: id, title, author, genre, publication_year, and price.
Solución
SELECT title, author, genre
FROM books
WHERE publication_year > 2015;
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 2. Capítulo 6
Query Result| No query executed yet... |
