Total Query: Create a query to display the names of departments, the average purchase price of the department’s devices, and the number of the devices in each department, for those departments whose average device price is higher than $200.
【***Note: for this query, you need to bring in the relevant tables to enable the JOIN of the tables needed. In other words, those tables needed may need some other tables to go in between to bring them together. However, ONLY CHOOSE THOSE FIELDS NEED TO SHOW TO PARTICIPATE IN THE QUERY; in other words, you might need to bring in some tables whose fields you don’t need at all, just to enable the joining of other tables】
Data table used:
(DeviceTbl & DeptTbl on Tech_Support)
3. Calculated field + total query: This time use Restaurant DB.
Create a total query which will display, for each type of service, (1) the number of restaurants of each type, (2) the average of a newly created field named “SalesPerSqFt” (the formula should be obvious from the name of the new field), and (3) the highest sales per square foot in each type. Sort the results by (2).Values Highest to lowest. (Descending)
Write a short discussion on the results of this query: what did you learn from the results involving the newly created field SalePerSqFt (point “2”)? Also briefly comment on “3” as related or in support of or in question of “2”.
0 comments