in Databases edited by
929 views
0 votes
0 votes
Product(maker, model, type)

PC(model, speed, ram, hd, price)

Laptop(model, speed, ram, hd, screen, price)

Printer(model, color, type, price)

Find the maker(s) of the PC(s) with the fastest processor among all those PC ’s that have the smallest amount of RAM

pls check if my SQL query is correct or not

select maker from Product where model IN(

                               select p.model from PC p where p.speed IN(

                                                                       select max(p1.speed) from PC p1 where p1.ram IN(

                                                                                                                   select MIN(p2.ram) from PC p2)))
in Databases edited by
by
929 views

Please log in or register to answer this question.

Related questions