-
Notifications
You must be signed in to change notification settings - Fork 93
/
sql.txt
14 lines (9 loc) · 947 Bytes
/
sql.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
(1) Using the Customer Table, select the CustomerName, ContactName, and Country. Use ORDER BY to order by Country.
Use LIMIT and OFFSET to get entries 11 through 20. Paste your SQL statement below.
(2) Select all columns from the Customer table where the ContactName starts with A. Paste your SQL statement below.
(3) Select all columns from the OrderDetails table where the ProductID is 51 and the quantity is greater than 10.
Paste your SQL statement below.
(4) Insert 3 rows into the Products table. Note that you will have to specify a valid SupplierID and CategoryID,
corresponding to rows from the Supplier and Category tables. Paste your three SQL statements below.
(5) Update the two top rows of the Products Table to increase the price by 1.50. (Get SQL to do the addition for you.) Paste your SQL statement below.
(6) Delete all rows of the Products Table where the price is less than 7.00. Paste your SQL statement below.