Cursusinhoud
Introduction to SQL
Introduction to SQL
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.
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.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
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.
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.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties