The Gateway to Computer Science Excellence
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 by Active (5.2k points)
edited by | 42 views

Please log in or register to answer this question.

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,741 questions
57,253 answers
104,700 users