Introduction - If you have any usage issues, please Google them yourself
one from the customer table for the names of all customers and telephone. Two inquiries inventory of more than 1,000 commodities, stocks on average by sequencing. Three inquiries each customer's total amount of orders. Four inquiries the first half of 2005 (January 1 to June 30) the total number of orders for more than 5,000 products. Five, all inquiries Beijing customer order information, including the serial number of orders, the customer's name, trade names, the numbers. 6, inquiries all goods and the time of the number sold. 7, no orders for the commodity information. 8, inquiries every commodity in total sales volume and the total amount.
Packet : 59564344实验 4 查询数据库.rar filelist
实验 4 查询数据库.doc