4. The SELECT Statement

Activity 4.01: Displaying Particular Columns from the Table

Solution:

1. In the New Query window, switch to the PACKT_ONLINE_SHOP database:

   USE PACKT_ONLINE_SHOP

2. Write the following query, to extract the required data, in the desired format:

   SELECT FirstName as 'First Name', LastName as   'Last Name', Phone as 'Phone Number'
   FROM Customers

3. Run the query. Your output should be as follows:

Figure 4.21: Columns from the Customers table

The query will list all the rows of the FirstName, LastName, Phone columns renamed as First Name, Last Name, and Phone Number.

Activity 4.02: Extracting the Top Five Highest Paid Items

Solution:

1. Execute the following query:

   SELECT 
       Products.ProductName as 'Product Name',
       Products.NetRetailPrice as 'Product Retail Price',
       Products.AvailableQuantity as &apos...