Home

Welcome to the SQL-Projects wiki!

University of Utah Health Systems - SQL test DBA_PreTest.pdf – This file includes four questions that you need to answer. It also includes instructions on installing Microsoft SQL Server, table descriptions and the database diagram.

Table_Creation.sql - This file contains the SQL script to create the database and tables and insert records needed to answer the questions.

Sample_Data_for_Reference.xlsx - This file contains the sample data that have been created using the ‘Table_Creation.sql’ script. It is provided to you for reference.

Answer 1.sql - Query for the first question Answer 2.sql - Query for the second question Answer 3.sql - Query for the third question - version 1 ( pivot data for months of 2016 and 17 together) Answer 3_2.sql - Query for the third question - version 2 ( pivot data for months of 2016 and 17 separately) Answer 4 is in the Answers.pdf file along with Answers 1,2 and 3.