edited by
945 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)))
edited by

Please log in or register to answer this question.

Related questions

1 votes
1 votes
3 answers
2
aditi19 asked May 18, 2019
1,283 views
Class(name, meets_at, room, fid)Faculty(fid, fname, deptid)Find the names of faculty members who teach in every room in which some class is taught
0 votes
0 votes
1 answer
4
rayhanrjt asked Jan 6, 2023
789 views
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.