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 Printer model color type price 3001 True ink jet 99 3002 False laser 239 3003 True laser 899 3004 True ink jet 120 3005 False laser 120 3006 True ink jet 100 3007 True laser 200 PC model speed ram hd price 1001 2 66 1024 250 2114 1002 2 10 512 250 995 1003 1 42 512 80 478 1004 2 80 1024 250 649 1005 3 20 512 250 630 1006 3 20 1024 320 1049 1007 2 20 1024 200 510 1008 2 20 2048 250 770 1009 2 00 1024 250 650 1010 2 80 2048 300 770 1011 1 86 2048 160 959 1012 2 80 1024 160 649 1013 3 06 512 80 529 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 printer

The Answer is in the image, click to view ...

Question: 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

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.

**Printer**
model	color	type	price
3001	True	ink-jet	99
3002	False	laser	239
3003	True	laser	899
3004	True	ink-jet	120
3005	False	laser	120
3006	True	ink-jet	100
3007	True	laser	200

PC
model	speed	ram	hd	price
1001	2.66	1024	250	2114
1002	2.10	512	250	995
1003	1.42	512	80	478
1004	2.80	1024	250	649
1005	3.20	512	250	630
1006	3.20	1024	320	1049
1007	2.20	1024	200	510
1008	2.20	2048	250	770
1009	2.00	1024	250	650
1010	2.80	2048	300	770
1011	1.86	2048	160	959
1012	2.80	1024	160	649
1013	3.06	512	80	529

**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	printer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hardware.accdb Query 1 (2 pts) Find the makers that produce printers, but do not produce PCs or laptops. Query 2 (2 pts) For each maker that produces printers, find the number of printer models...

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...

Query 1 (2 pts) Find all courses taught by Mozart. For each such course, output the title, semester, and year. Query 2 (2 pts) Find the names of all students who took both Intro. to Computer Science...

Query 1 (2 pts) Find all courses that have no prerequisites. Output a one-column table with the titles of those courses. Write this query without join or product. Query 2 (2 pts) Find the...

For each maker that produces PCs, find the average price of the models of PCs produced by this maker. Round the price up to the nearest integer. Output a table consisting of two columns: (maker,...

Create tables as described with sample data, and then write SQL queries for the given problems. */ DROP TABLE Printer CASCADE CONSTRAINTS; DROP TABLE Laptop CASCADE CONSTRAINTS; DROP TABLE PC CASCADE...

Responsibility Center Presentation Imagine you have been selected by your manager to present a training session to a group of new employees. The new hires do not have accounting backgrounds and have...

Create tables as described with sample data, and then write SQL queries for the given problems. Note your confidence levels for each SQL query on a scale of [0, 10]. */ DROP TABLE Printer CASCADE...

Query 1 (2 pts) Write a query that outputs another version of table of prerequisites, where courses are represented by their titles, not by their IDs. In the resulting table, rename the columns...

Colour World prepares and packages paint products. Colour World has two departments: (1) Blending and (2) Packaging. Direct materials are added at the beginning of the blending process (dyes) and at...

According to Forbes, Persuasion is not Manipulation - Manipulation is coercion through force to get someone to do something that is not in their own interest. Persuasion is the art of getting people...

Folate deficiency may cause all the following EXCEPT: Select one: a . no answer is correct because folate deficiency may cause all of these. b . poor growth. c . microcytic anemia. d . neural tube...

A random sample of 43 biology students in a science program are selected for a study. Of those selected, only 27 passed the mid term exam. At the 5% significance level, is there sufficient evidence...

e. In how many cases were people depicted in stereotypical rolesfor example, African Americans as athletes, or women as homemakers?

1. Discuss the four components of language.

a. How many different groups were represented?