Microsoft Access Query 2 (2 pts) For each maker that produces printers, find the
ID: 3741175 • Letter: M
Question
Microsoft Access Query 2 (2 pts)
For each maker that produces printers, find the number of printer models produced by this maker. Output a table consisting of two columns: (maker, number of models). Sort the result by numbers of models in ascending order.
Product maker model type A 1001 pc A 1002 pc A 1003 pc B 1004 pc B 1005 pc B 1006 pc C 1007 pc D 1008 pc D 1009 pc D 1010 pc E 1011 pc E 1012 pc E 1013 pc E 2001 laptop E 2002 laptop E 2003 laptop A 2004 laptop A 2005 laptop A 2006 laptop B 2007 laptop F 2008 laptop F 2009 laptop G 2010 laptop E 3001 printer E 3002 printer E 3003 printer D 3004 printer D 3005 printer H 3006 printer H 3007 printerExplanation / Answer
Answer is as follows :
Query for given scenario in MS Access is :
SELECT maker, COUNT(model) AS No_Models FROM Product GROUP BY maker ORDER BY model ASC ;
The query first group the table in terms of maker and count the corresponding model of maker and order them in ascending order in terms of model.
if there is any query please ask in comments....