Give the SQL statements output for the following data reque

Give the SQL statements & output for the following data requests:

Which books aren’t in the Fitness category? List each book title and category.

Solution

SELECT TITLE, CATEGORY FROM BOOKS WHERE CATEGORY <> \'Fitness\';

OR

SELECT TITLE, CATEGORY FROM BOOKS WHERE CATEGORY != \'Fitness\';

This is the SQL query for the table BOOKS where attributes of the table are TITLE, CATEGORY