This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Challenge 1: Find the 10 longest books | |
select title | |
from books | |
group by title | |
order by max(pages) desc | |
limit 10; | |
-- Challenge 2: List all books published in 2020 | |
select title from books where title is not null and published_date = 2020; |