After going through this module's learning activities, solve the following exercises:

Bowling $-$ How many tournaments are there? $(1$ row, with value $20)$

Entertainment Agency $-$ Show me the list of entertainers. For each entertainer, I want the ID and stage name. Sort it by name $(13$ rows$)$

Recipes $-$ Show the list of ingredients sorted by name. For each ingredient, show only its name $(79$ rows$)$

Sales Orders $-$ Show a list of customers who are not in Texas. For each customer, show the customer's name, city and state $(22$ rows$)$

School Scheduling $-$ Show me a list of subjects in the art and history categories $(9$ rows$)$