查询与视图作业（Query and view jobs）.docVIP

查询与视图作业（Query and view jobs） Problem 01 Designing a query using query designer requires as follows: (1) based on free tables, currency_sl.dbf and rate_exchange.dbf; (2) contains the field name, foreign currency name, holding quantity, cash buying price and the expression holding quantity * buying price of notes; (3) sort ascending first by name, and then descending sort by number of holds; (4) query destination is table results; (5) after you have completed the design, save the query as a query file and run the query; Problem 02 A query QQ, query membership No. (from customer), name (from customer), a member of the purchase of goods (from article), the price (from orderltem), the number (from orderltem) and the amount (number of orderltem. at *orderltem.), the results do not sort the results dont sort where is the query table SS; queries to qq.qpr, and run the query. Problem 03 The query designer creates a query based on Xuesheng and Chengji, the statistics of each class (first 8 digits number string number) of male and female students in English courses, their lowest score the highest score and the average score. The query result contains number, gender, the highest score and the average score of 5 fields; the record number sorted by ascending order, the same class, boys and girls in the front in the post; check the whereabouts of table table1. Finally, save the query in the query1.qpr file and run the query. Problem 04 1, using the query designer to create queries, from Xuesheng and Chengji table for math, English and information technology three courses are above 85 (inclusive), or mathematics, English is above 90 (inclusive) and information technology in more than 75 points (including student records). The query results include 5 fields: student number, name, mathematics, English and information technology. Each record is sorted according to the number of students in descending order. The destination of inquiry is table table1. Finally, save the query to the que