(Solved):   (2) Log into your MS SQL Server database account, run SQL statements in the given file nam ...

 

(2) Log into your MS SQL Server database account, run SQL statements in the given file named mssql.create.sql, which creates the tables in the database; then run SQL statements in the given file named mssql.insert.sql, which inserts data into the tables in the database. (Do NOT make any change to the two given script files.) (3) Create a new file named lab5.select.sql and write SQL statements in the file to answer the following queries: Q1: List of the consumer cities and consumer names by city ordered alphabetically Q2: List of the computer transactions ordered by transaction value in descending order Q3: List the number of consumer cities Q4: List the number and average value of computer transactions Q5: List the total computer offer value in Stevens Point Q6: List of the number and average value of computer requests in Wausau