In this exercise you will use Azure Data Studio $($ADS$)$ to browse your local database and runs SQL commands on the AP database.

Before you do the exercises for this assignment

If you$$re working on your own computer, you$$ll need to set up your system as described in appendix A before you can do these exercises.

Exercises

Use Azure Data Studio to view all of the databases that are available from your server.

View the tables that are available from the AP database.

Please paste a screenshot of the tables in the tables folder below

View the columns that are available from the Invoices table. Note the primary and foreign keys for this table and the definition for each column.

Please paste a screenshot of the columns in the Invoices table below

Right$-$click on the Vendors table and select Design to display the Vendors table in a Table Designer window. Review the properties for each column in this table. In particular, note that the VendorID column is defined as an identity column.

Please paste a screenshot of the VendorID column$$s properties below

Open a new Query Editor window and enter this SELECT statement:

SELECT VendorName, VendorState

FROM Vendors

WHERE VendorState $=\text{'}$CA$\text{'}$

Press F$5$ to run the query and display the results. If you get an error message that indicates that $$Vendors$$ isn$$t a valid object, select the AP database from the drop$-$down list in the toolbar.

Save the query with a name of VendorsInCA and close it$.$

Open the saved query named VendorsInCA. Then, click the Run button in the toolbar to run it$.$

Please paste a screenshot of the query$$s result below

Create a new query and enter this SELECT statement:

SELECT InvoiceDate, SUM$($InvoiceTotal$)$ AS Total

FROM Invoices

Save the query with a name of Chart$1.$

Run the query and view the results. Note that it includes one row for each invoice date and that each row includes the total for the invoices on each date.

Please paste a screenshot of the query$$s result below

Click the Charts icon in the Results tab. Adjust the settings to create a bar graph showing the invoice totals by date. Hint: Set the data direction to vertical. Note that this chart displays one bar for each date that has an invoice.

Please paste a screenshot of the query$$s result below

Save the Chart$1$ query with a new name of Chart$2.$

Edit the query so it becomes this SELECT statement:

SELECT DATE$\_$BUCKET$($MONTH$,1,$ InvoiceDate$)$ AS Month, SUM$($InvoiceTotal$)$ AS Total

FROM Invoices

GROUP BY DATE$\_$BUCKET$($MONTH$,1,$ InvoiceDate$)$;

To do that, you need to add the DATE$\_$BUCKET function in two places. When you do$,$ make sure to type the code exactly as shown above.

Please paste a screenshot of the query$$s result below

Run the query and note that the results now show one row for each of the months that contain invoices.

Click the Charts icon in the Results tab. Adjust the settings to create a bar graph showing the invoice totals by month. Note that this chart displays one bar for each month that has an invoice.

Please paste a screenshot of the query$$s result below