Databases Reporting with SQL Ordering, Limiting and Paging Results Limiting Results

I am having problems writing the code for this challenge. Can someone please help me! Thanks

I tried different keywords but dont know where to place them

2 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,289 Points

You just need to eliminate the word AND

SELECT * FROM books WHERE genre = "Fantasy" ORDER BY first_published ASC LIMIT 5;

SELECT * FROM books WHERE genre = "Fantasy" AND ORDER BY first_published ASC LIMIT 5;