(Solved): A4 - Simple Queries: 2 bonus points for early submission...
A4 - Simple Queries: 2 bonus points for early submission
Started: Oct 9
BONUS POINTS FOR 24HR EARLY SUBMISSION. THEY WILL BE APPLIED ONLY IF ALL QUESTIONS WERE ANSWERED COMPLETELY - NO BONUS POINTS FOR MISSING FILES.
This is an INDIVIDUAL assignment - do not discuss answers with other class members other than general questions on slack.
Write the SQL scripts (queries) to answer each question. Use the Family Adventure Resorts database that is provided. Test the scripts by coding them 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.
All screenshots 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 (screen shots) and notepad file (scripts) will be submitted as:
(submit each file separately in the areas provided).....
Question 1 4 pts
Retrieve all condos in building A, Include the unit number, beds, baths, and fees. List largest condos first. Label your unit numbers as building a units. Do not include the building number data in the result table.
Question 2 4 pts
(4) What is the most number of days, the least number of days, and the average number of days our employees have been with the resort? Label all columns most days employed, least days employed and average days employed. Code each on a separate line.