Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Query 4 (2 pts) Find the PC models with the maximum speed. Output a table consisting of five columns: (model, maker, speed, ram, price). Product
Query 4 (2 pts)
Find the PC models with the maximum speed. Output a table consisting of five columns: (model, maker, speed, ram, price).
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 |
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started