Для всех абонентов вывести последнею сумму долга, с указанием адреса и фамилии

select client.c_last_name, city.c_city. street.c_street, computation.n_debt from client, city, street, computation where client.n_client = computation.n_client and client.n_city = city.n_city and client.n_street = street.n_ctreet and d_computatiom = ( select max(a.d_computation) from computation a where a.n_client = client.n_client)
select client.c_last_name, city.c_city. street.c_street, computation.n_debt from client, city, street, computation where client.n_client = computation.n_client and client.n_city = city.n_city and client.n_street = street.n_ctreet and d_computatiom = max(d_computation)
select client.c_last_name, city.c_city. street.c_street, computation.n_debt from client, city, street, computation where client.n_client = computation.n_client and client.n_city = city.n_city and client.n_street = street.n_ctreet and n_debt = ( select max(a.n_debt) from computation a )
select client.c_last_name, city.c_city. street.c_street, computation.n_debt from client, city, street, computation where client.n_client = computation.n_client and client.n_city = city.n_city and client.n_street = street.n_ctreet group by client.c_last_name, city.c_city. street.c_street
select client.c_last_name, city.c_city. street.c_street, max(computation.n_debt) from client, city, street, computation where client.n_client = computation.n_client and client.n_city = city.n_city and client.n_street = street.n_ctreet

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