Give the SQL statements output for the following data reque

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

Display the book title and category for all books in the Children and Cooking categories. Create three different queries to accomplish this task: a) a search pattern operation, b) a logical operator, and c) another operator not used in a or b.

Solution

a) select bookTitle,category from Book where category like \'Ch%\' OR category like \'Cook%\'

b) select bookTitle,category from Book where category=\'Children\' AND category=\'Cooking\'

c) select bookTitle,category from Book where category=\'Children\' UNION select bookTitle,category from Book where category=\'Cooking\'