Assignment 4 Grouping, Nesting, Views, Transactions - SQL Queries (49 points) Write the SQL scripts (queries) to answer the following questions. Use the Family Adventure Resorts database that is provided. Your queries will be copied in the New Query window in SQL Server from your notepad file All results will be shown in the results area. Take a screenshot of each query/result-one per page (similar to the example shown below, cropping out the unnecessary areas) and insert into a Word document must be read without magnifying glasses! incorrect snapshot formats = 5 points deduction! All snapshots will be inserted into ONE document in the correct numerical order (1, 2, 3,...). When finished save your Word document as a .pdf file. The .pdf file and notepad file will be submitted as YourLastName-A4.pdf and YourLastName-A4.txt Incorrect naming of submission files2 points deduction each! Make sure you use comment statements to include your name, the assignment number (first screen only), and each full question including the question number-5 point loss for missing comments. (Comments begin with/* and end with */ - see image below) Use column and table aliases to simplify your queries or to make your output readable. Create queries as if you cannot see the data (start with what you know no hardcoding!). There are 10 questions. Include SQLQuery4.sql- wp...URITEkmser (67))" SQLQueryl.sql-wp...URITE kmoser (58) X Example Assignment 5 YourNameHere/ /*How many children does each guest have? List the full name of the guest, the spouse name, and the number of children labeled Number of Children. List the largest families first. */ Increase the 96 of your query window so that queries are easily read (without' straining to see them!) Se 150% Results-Messages Number of Chldren Curtis a Mary Ann June homas Sarah 4 One query per screen shot -the entire script with 4 comments and the entire result show in the 3 corresponding panes. (If the entire result does Marchand Sam Thomas Bob 4 Sue 5 Jack 6 Steve Jones Chapman Sarah Diane not fit in one screen after adjusting the panes, make sure the number of rows in the result shows as in the circled area. Keep the correct 3 numbering sequence. Resize the window as long Tony Tulsa 8 Adam cLean Judy 9 Brooke Peterson Greg Hice 10 Kyle Laura 2as all circled areas are displayed 12 13 Mura Northwood Stephanie Rufalo Query executed successfully. wpccis03 (10.50 SP1) ASURITENkmoser (58) kmoser 0000:00 23 rows Assignment 4 Grouping, Nesting, Views, Transactions - SQL Queries (49 points) Write the SQL scripts (queries) to answer the following questions. Use the Family Adventure Resorts database that is provided. Your queries will be copied in the New Query window in SQL Server from your notepad file All results will be shown in the results area. Take a screenshot of each query/result-one per page (similar to the example shown below, cropping out the unnecessary areas) and insert into a Word document must be read without magnifying glasses! incorrect snapshot formats = 5 points deduction! All snapshots will be inserted into ONE document in the correct numerical order (1, 2, 3,...). When finished save your Word document as a .pdf file. The .pdf file and notepad file will be submitted as YourLastName-A4.pdf and YourLastName-A4.txt Incorrect naming of submission files2 points deduction each! Make sure you use comment statements to include your name, the assignment number (first screen only), and each full question including the question number-5 point loss for missing comments. (Comments begin with/* and end with */ - see image below) Use column and table aliases to simplify your queries or to make your output readable. Create queries as if you cannot see the data (start with what you know no hardcoding!). There are 10 questions. Include SQLQuery4.sql- wp...URITEkmser (67))" SQLQueryl.sql-wp...URITE kmoser (58) X Example Assignment 5 YourNameHere/ /*How many children does each guest have? List the full name of the guest, the spouse name, and the number of children labeled Number of Children. List the largest families first. */ Increase the 96 of your query window so that queries are easily read (without' straining to see them!) Se 150% Results-Messages Number of Chldren Curtis a Mary Ann June homas Sarah 4 One query per screen shot -the entire script with 4 comments and the entire result show in the 3 corresponding panes. (If the entire result does Marchand Sam Thomas Bob 4 Sue 5 Jack 6 Steve Jones Chapman Sarah Diane not fit in one screen after adjusting the panes, make sure the number of rows in the result shows as in the circled area. Keep the correct 3 numbering sequence. Resize the window as long Tony Tulsa 8 Adam cLean Judy 9 Brooke Peterson Greg Hice 10 Kyle Laura 2as all circled areas are displayed 12 13 Mura Northwood Stephanie Rufalo Query executed successfully. wpccis03 (10.50 SP1) ASURITENkmoser (58) kmoser 0000:00 23 rows
