Query 4 (2 pts) Find the PC models with the maximum speed. Output a table consis
ID: 3741680 • Letter: Q
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 printerExplanation / 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);