Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MongoDB Applied Design Patterns Practical Use Cases With The Leading NoSQL Database

Authors: Rick Copeland

1st Edition

1449340040, 978-1449340049

More Books

Students also viewed these Databases questions