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');
- Slides: 32