Найти Адреса 10 самых крупных потребителей холодной воды

select * from ( select client.* from client where n_client = (select n_client from computation where n_info_cold = (select max(n_info_gold) from computation ) order by n_info_gold DESC) where rownum <=10
select client.* from client where n_client = (select n_client from computation where max(n_info_cold) = (select n_info_gold from computation ) and rownum=10 order by n_info_gold DESC
select client.c_last_name, street, city from client, computation where client.n_client = computation.n_client and n_client = (select n_client from computation where n_info_cold = (select max(n_info_gold) from computation ) and rownum <=10

Для просмотра статистики ответов нужно залогиниться.