Query 4 (2 pts) Find the PC models with the maximum speed. Output a table consis

Question

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

Explanation / Answer

Answer:

select p.model, p.maker, pc.speed, pc.ram, pc.price from product p, PC pc where pc.model=p.model and pc.speed in (select max(speed) from PC);

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.