Lab 10

 Objective

SQL Script required → LAB SQL Script

Using some of the SQL commands you have learned, create a SQL statement to answer the following questions. Once you have created the SQL command, copy and paste your Query and results and submit via a word document (copy-paste results)

Using the Customers table of sql_store

1. Use the SQL command to list all customers who live in San Antonio.

2. Use the SQL command to list customers with less than 1000 points.

3. Use the SQL command to list all customers who were born in the 70’s

Using the products table of sql_inventory

1. Use the SQL command to name and price of the items where there are more than 60 in stock

2. Use the SQL command to name, price and quantity of all items over 4.00