Create an instance of SQL Server Express 2012 on a cloud provider (AWS, Azure, etc.). Attach the AdventureWorksLT2012 database (which can be found on CodePlex).
The first step I took was to create an Azure account with Microsoft. I then searched the marketplace on Azure for SQL Server Express 2012. I then deployed the Virtual Machine running SQL Server Express 2012. I then used the SQL Database tool built into Azure to connect a sample database containing the AdventureWorks2012 data. I followed along the tutorials in Microsoft’s documentation to figure out exactly how to do this. Now that I have my server up and running it is time to connect to the database and run queries. One issue I was running into was finding a good tool to run SQL queries from my Macbook. I tried RazorSQL but after spending an hour trying to troubleshoot the connection with no help from the error messages. I decided to use a different tool called SQLPro after downloading and launching SQLPro I knew what my problem was… I was doing everything right I was just using the wrong password to connect. Now that I have everything connected I can start running queries.
Author some SQL queries against this database, demonstrating knowledge of several of the following: joins, grouping, window functions, common table expressions, etc. Also, author some queries against the system tables to bring back some information about the SQL Server instance or the AdventureWorksLT2012 database.
Please provide the queries and results for the below: