Архив форумов ЦИТФорума

[Светлячок]

Схема данных

Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)

Найдите производителей принтеров, которые производят ПК с наименьшим объемом RAM и с самым быстрым процессором среди всех ПК, имеющих наименьший объем RAM. Вывести: Maker
http://www.sql-ex.ru/exercises.php#answer_ref 25 задание

Написала запрос:
select distinct maker
from product
where model = any
(select model
from pc
where ram = (select min(RAM)
from pc a)
and exists
(select model
from pc
where speed = (select max(speed)
from pc a)
)
)

а результат неверен помогите плиз!!!!!!!!

[Иван царевич]

попробуй так ...

select distinct maker from product
from product p ,printer pr
where p.type = pr.type
and p.model = (select model from pc
where pc.ram = (select min(RAM) from pc )
and pc.speed = (select max(speed) from pc ) )

[Иван царевич]

попробуй так ...

select distinct maker from product
from product p ,printer pr
where p.type = pr.type
and p.model = (select model from pc
where pc.ram = (select min(RAM) from pc )
and pc.speed = (select max(speed) from pc ) )