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

Help with this question?

I am trying to grasp how to include the fantasy genre but need some help, what is the answer?

1 Answer

Steven Parker
Steven Parker
195,447 Points

You can limit a result set using a "WHERE" clause. So in this case, you might use this as part of your query:
WHERE genre = 'Fantasy'.

Remember that a "WHERE" clause will come after "FROM" but before "ORDER BY" or "LIMIT".