Write SQL Queries

Q3. (1) List all activity types and descriptions that the guests participated in during June. Label the output Activity Types and Popular Activities in June. Do not include duplicate listings. Include the number of people participating in each activity and label the output, Number of Participants. Store the result in June_Activities. Show the output, listing the description first then the type, and finally the number participating. Order the output by type. (one screenshot)

Q4. (1) Write the fully nested query to display the city and state of all guests who reserved a horseback riding activity in June or July.

Q5. (1) Unit C105 had quite a bit of damage after the last family stayed during the week of July 22, 2017. Write a fully nested query to obtain a list of the childrens names alphabetically and their ages. Label the names, Children Staying in C105 July 22nd Week.