database:SQL in 10 minutes

SELECT vend_name,prod_name,prod_priceFROM Vendors INNER JOIN ProductsON Vendors.vend_id = Products.vend_id;SELECT cust_name,cust_contact FROM CustomersWHERE cust_id IN (SELECT cust_idFROM OrdersWHERE order_num IN(SELECT order_numFROM OrderItemsWHERE prod_id = 'RGAN01'));SELECT cust_name,cust_contact FROM Customers,Orders,OrderItems WHERE Customers.cust_id = Orders.cust_idAND OrderItems.order_num = Orders.order_numAND prod_id = 'RGAN01';SELECT cust_name,cust_contact FROM Customers AS C, Orders AS O, OrderItems AS OI WHERE C.cust_id = O.cust_idAND OI.order_num = O.order_numAND prod_id = 'RGAN01';SELECT C1.cust_id,C1.cust_name,C1.cust_contactFROM Customers AS C1,Customers AS C2WHERE C1.cust_name = C2.cust_nameAND C2.cust_contact = 'jim Jones';SELECT C.cust_id,O.order_numFROM Customers C INNER JOIN Orders OON C.cust_id = O.cust_id;SELECT C.cust_id,O.order_numFROM  Orders O FULL OUTER JOIN Customer CON  O.cust_id =  C.cust_id;SELECT cust_name,cust_contact,cust_emailFROM CustomersWHERE cust_state IN ('IL','IN' ,'MI')UNION ALLSELECT cust_name,cust_contact,cust_emailFROM CustomersWHERE cust_name = 'Fun4All'ORDER BY cust_name,cust_contact;INSERT INTO CustomersVALUES('100000006','Toy land','123 any street','New York','NY','111111','USA',null,NULL);CREATE TABLE Custcopy AS SELECT * FROM Customers;UPDATE CustcopySET cust_email = '[e-mail]'WHERE cust_id = '1000000005';DELETE FROM CustcopyWHERE cust_id = '1000000006';ALTER TABLE VendorsADD vend_phone CHAR(20);CREATE VIEW ProductCustomers AS SELECT cust_name,cust_contact,prod_idFROM Customers,Orders,OrderItemsWHERE Customers.cust_id = Orders.cust_idAND OrderItems.order_num = Orders.order_num;SELECT cust_name,cust_contactFROM ProductCustomersWHERE prod_id = 'RGAN01';//拼接SELECT Concat(vend_name,' (',vend_country,')')FROM VendorsORDER BY vend_name;CREATE VIEW CustomerEmaillist AS SELECT cust_id,cust_name,cust_emailFROM CustomersWHERE cust_email IS NOT NULL;SELECT * FROM CustomerEmaillist;CREATE PROCEDURESTART TRANSACTIONDELETE FROM ORDER;ROLLBACK;COMMITSAVEPOINTSAVEPOINT delete1;SAVE TRANSACTION delete1;ROLLBACK TO delete1;DECLARE CustCursor CURSORFOR SELECT  * FROM CustomersWHERE cust_email IS NULL;OPEN CURSOR CustCusorFECTH NEXT FROM CustCursorCLOSE CustCursorPRIMARY KEYALTER TABLE VendorsADD CONSTRAINT PRIMARY KEY (vend_id);ALTER TABLE OrdersADD CONSTRAITFOREIGN KEY (cust_id) REFFERENCES Customers (cust_id)CREATE INDEX prod_name_indON PRODUCTS (prod_name);

the code in the book of Ben Forta.