Example 2 SELECT Customernum Customer Name Balance FROM

Example 2 SELECT Customernum, Customer. Name, Balance FROM Customer; 1

Example 3 SELECT * FROM Part; 2

Example 4 SELECT Customername FROM Customer WHERE Credit. Limit=10000; 3

Example 5 SELECT Customer. Num FROM Customer WHERE Customer. Num='148'; 4

Example 6 SELECT Customername FROM Customer WHERE City = ‘Grove'; 5

Example 7 SELECT Customer. Name, Credit. Limit, Balance FROM Customer WHERE Credit. Limit>Balance; 6

Example 8 SELECT Description FROM Part WHERE Warehouse=‘ 3’ AND On. Hand>20; 7

Example 9 SELECT Description FROM Part WHERE Warehouse=‘ 3’ OR On. Hand>20; 8

Example 10 SELECT Description FROM Part WHERE NOT Warehouse=‘ 3’; 9

Example 11 SELECT Customer. Num, Customer. Name, Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000; 10

Example 12 SELECT Customer. Num, Customer. Name, Credit. Limit-Balance AS Available. Credit FROM Customer; 11

Example 13 SELECT Customer. Num, Customer. Name, Credit. Limit-Balance AS Available. Credit FROM Customer WHERE Credit. Limit > Balance; 12

Example 14 SELECT Customer. Num, Customer. Name, Street, City, State, Zip FROM Customer WHERE Street LIKE ‘*Oxford*’; 13

Example 15 SELECT Customer. Num, Customer. Name, Credit. Limit FROM Customer WHERE Credit. Limit IN (7500, 10000, 15000); 14

Example 16 SELECT Customer. Num, Customer. Name, Credit. Limit FROM Customer ORDER BY Customer. Name; 15

Example 17 SELECT Customer. Num, Customer. Name, Credit. Limit FROM Customer ORDER BY Credit. Limit DESC, Customer. Name; 16

Example 18 SELECT count(*) FROM Part WHERE Class="HW";

Example 19 SELECT count(*), Sum(Balance) FROM Customer;

Example 20 SELECT count(*) AS Customer. Count, Sum(Balance) AS Balance. Total FROM Customer;

Example 21 SELECT Order. Num FROM Order. Line WHERE Part. Num IN (SELECT Part. Num FROM Part WHERE Warehouse='3');

Example 22 SELECT Rep. Num, Count(*) AS Num. Of. Customer, Avg(Balance) AS Avg. Balance FROM Customer GROUP BY Rep. Num ORDER BY Rep. Num;

Example 23 SELECT Customer. Rep. Num, count(*) AS Num. Customer, Avg(Balance) AS Average. Balance FROM Customer GROUP BY Customer. Rep. Num HAVING Count(*)<4 ORDER BY Customer. Rep. Num;

Example 23 -1 SELECT Customer. Rep. Num, count(*) AS Num. Customer, Avg(Balance) AS Average. Balance FROM Customer WHERE Credit. Limit<10000 GROUP BY Customer. Rep. Num HAVING Count(*)<3 ORDER BY Customer. Rep. Num;

Example 24 SELECT Customer. Num, Customer. Name, Rep. Num, Last. Name, First. Name FROM Customer, Rep WHERE Customer. Rep. Num=Rep. Num;

Example 25 SELECT Customer. Num, Customer. Name, Rep. Num, Last. Name, First. Name FROM Customer, Rep WHERE Customer. Rep. Num=Rep. Num AND Credit. Limit=10000;

Example 26 SELECT Orders. Order. Num, Orderdate, Customer. Num, Customer. Name, Part. Num, Description, Num. Ordered, Quoted. Price FROM Orders, Customer, Order. Line, Part WHERE Customer. Num=Orders. Customer. Num AND Orders. Order. Num=Order. Line. Order. Num AND Order. Line. Part. Num=Part. Num;

Example 27 SELECT Customer. Num, Customer. Name FROM Customer WHERE Rep. Num='35' UNION SELECT Customer. Num, Customer. Name FROM Customer, Orders WHERE Customer. Num=Orders. Customer. Num;

Example 28 UPDATE Customer SET Street = '1445 Rivard' WHERE Customer. Num='524';

Example 29 INSERT INTO Rep VALUES ('16', 'Rands', 'Shron', '826 Raymond', 'Altonville', 'FL', '32543', 0, 0. 05);

Example 30 DELETE * FROM Order. Line WHERE Part. Num='BV 06';

Example 31 SELECT * INTO Small. Cust FROM Customer WHERE Credit. Limit<=7500;

Example 32 CREATE TABLE Employee; INSERT INTO Employee VALUES ('987654321', 'Choi', 'Yong', '9001 Stockdale', 'Bakersfield', 'CA', '123456789');