SQL (ORDER BY, WHERE)
We're using the library database again. There's a books table. There's a title, author, genre and first_published column.
Write a query to obtain the first 5 books in the Fantasy genre ordered by the year released. Oldest first. Select all columns.
I WROTE THIS CODE BUT IT SAYS IS MISSING WHERE.
SELECT * FROM books ORDERED BY genre ASC LIMIT 5;
Yes is order by. How can I restrict it?
I really much appreciate your time and effort in answering my question, you couldn't be more specif. Thanks really much, Mr Paden.