ÔÓÍÊÖÈß Â ÊÎÐÐÅËÈÐÎÂÀÍÍÎÌ ÏÎÄÇÀÏÐÎÑÅ
Âûäàòü íîìåð ïîñòàâùèêà, ñîñòîÿíèå è ãîðîä äëÿ âñåõ ïîñòàâùèêîâ, ó êîòîðûõ ñîñòîÿíèå áîëüøå èëè ðàâíî ñðåäíåìó äëÿ èõ êîíêðåòíîãî ãîðîäà.
SELECT ÍÎÌÅЗÏÎÑÒÀÂÙÈÊÀ, ÑÎÑÒÎßÍÈÅ, ÃÎÐÎÄ
FROM S SX
WHERE ÑÎÑÒÎßÍÈÅ > =
(SELECT AVQ (ÑÎÑÒÎßÍÈÅ)
FROM S SY
WHERE SY. ÃÎÐÎÄ = SX. ÃÎÐÎÄ);
Ðåçóëüòàò: