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