Посчитать потребление воды по каждой улице в базе

select c_street, count(*) from street group by c_street
select c_street, sum(n_info_gold) from street, computation where street.n_client = computation.n_client group by c_street
select c_street, sum(n_info_gold) from street, computation, client where client.n_client = computation.n_client and client.n_street = street.n_street
select c_street, sum(n_info_gold) from street, computation, client where client.n_client = computation.n_client and client.n_street = street.n_street group by c_street

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