Exercises
In these exercises, you’ll use SQL Server Management Studio to create the MyGuitarShop database, to review the tables in the MyGuitarShop database, and to enter SQL statements and run them against this database.
Create the database
Start SQL Server Management Studio and open a connection using either Windows or SQL Server authentication.
Open the script file named CreateMyGuitarShop.sql
Execute the entire script by clicking the Execute button in the SQL Editor toolbar or by pressing F5. When you do, the Messages tab displays indicates whether the script executed successfully.
Review the database
In the Object Explorer window, expand the node for the database named MyGuitarShop so you can see all of the database objects it contains. If it isn’t displayed in the Object Explorer window, you may need to click on the Refresh button to display it.
View the data for the Categories and Products tables.
Navigate through the database objects and view the column definitions for at least the Categories and Products tables.

Questions 1. Write a SELECT statement that returns these column names and data from the Products table: ProductName The ProductName column ListPrice The ListPrice column DiscountPercent The DiscountPercent column DiscountAmount A column that’s calculated from the previous two columns DiscountPrice A column that’s calculated from the previous three columns
Sort the result set by discount price in descending sequence.
Write a SELECT statement that returns these columns from the Orders table:
OrderID The OrderID column
OrderDate The OrderDate column
ShipDate The ShipDate column
Return only the rows where the ShipDate column contains a null value.
Write a SELECT statement without a FROM clause that creates a row with these columns:
Price 100 (dollars)
TaxRate .07 (7 percent)
TaxAmount The price multiplied by the tax
Total The price plus tax
To