Вывести список клиентов, проживающих в Челябинске и не имеющих долгов по оплате за сентябрь 2008 года.

  • select client.*, computation.n_debt from client, computation where client.n_client = computation.n_client and d_computatiom = max(d_computatiom) and n_debt <= 0 and c_city like '%Челябинск%'
  • 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 = '01.09.2008' and n_debt <= 0 and c_city like '%Челябинск%'
  • 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 = min(n_debt) and c_city like '%Челябинск%'
  • select client.c_last_name, city.c_city. street.c_street, computation.n_debt from computation where d_computatiom = '01.09.2008' and n_debt <= 0 and c_city = 'Челябинск'
Для просмотра статистики ответов нужно залогиниться.