select distinct concat(c.first_name, ' ', c.last_name) as "Клиент"
  from CUSTOMER c
 where upper(c.first_name) in ('ВАСЯ', 'КОЛЯ', 'ПЕТЯ')
 order by 1

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент"
  from CUSTOMER c
 where upper(c.first_name) in ('ВАСЯ', 'КОЛЯ', 'ПЕТЯ')
 order by 1 desc nulls last

select distinct f.rental_rate as "Стоимость фильма"
  from FILM f
 order by 1

select f.title as "Фильм",
       f.rental_rate as "Стоимость фильма",
       f.replacement_cost as "Стоимость залога фильма"
  from FILM f
 where f.rental_rate > f.replacement_cost * 0.2
 order by 1

select f.title as "Фильм",
       f.length as "Продолжительность фильма"
  from FILM f
 where f.length between 100 and 110
 order by 1

select f.title as "Фильм",
       f.length as "Продолжительность фильма"
  from FILM f
 where f.length > 140
 order by 1

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       c.email as "Email клиента"
  from CUSTOMER c
 where lower(c.email) != c.email
 order by 1

select distinct concat(a.first_name, ' ', a.last_name) as "Актер"
  from ACTOR a
 where substr(a.first_name, 1, 1) = substr(a.last_name, 1, 1)
 order by 1

select distinct concat(a.first_name, ' ', a.last_name) as "Актер"
  from ACTOR a
 where upper(a.first_name) like 'Б%'
 order by 1

select f.title as "Фильм",
       f.description as "Сюжет фильма"
  from FILM f
 where position('КОШКИ' in upper(f.description)) > 0
    or position('КОШКА' in upper(f.description)) > 0
 order by 1

select f.title as "Фильм",
       f.description as "Сюжет фильма"
  from FILM f
 where position('МЫШЕК' in replace(upper(f.description), 'Ё', 'Е')) > 0
    or position('МЫШКА' in upper(f.description)) > 0
 order by 1

Комментарий: Поиск слова - это более сложный поиск, чем подстроки. Здесь если текст содержит "лукошки", тоже найдёт. Но средствами SQL нельзя реализовать нормальный полнотекстовый поиск, поэтому лучше не получится. Хотя можно ещё сюда добавить разные падежи, но надо ли...

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент"
  from CUSTOMER c
 where c.email is null
    or c.email = ''
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where f.release_year between 2020 and 2029
 order by 1

Результат не совпадает с эталоном

select f.title as "Фильм",
       f.length as "Продолжительность фильма"
  from FILM f
 where f.rating = 'NC-17'
   and f.length > 60
   and f.release_year <= 2000
 order by 2 desc nulls last

select count(p.payment_id) as "Количество платежей"
  from PAYMENT p
 where p.amount > 300

Комментарий: Здесь разпознаётся, что сумма - это не агрегатная функция, а поле с денежной величиной.

select distinct f.title as "Фильм"
  from FILM f
 where upper(f.title) like 'ДОМ%'
   and exists (select *
       from FILM_CATEGORY fc
       join CATEGORY ca on fc.category_id = ca.category_id
      where fc.film_id = f.film_id
        and ca.category_id = 11)
 order by 1

select f.title as "Название фильма",
       f.special_features as "Дополнительные материалы фильма"
  from FILM f
 where f.special_features is not null
   and f.special_features != ''
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where position('МНОГОНОЖКА' in upper(f.title)) = 0
 order by 1

select min(re.rental_date) as "Минимум даты начала аренды" from RENTAL re

select max(re.rental_date) as "Максимум даты начала аренды" from RENTAL re

select distinct f.title as "Фильм"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
 where re.rental_date = re.return_date
 order by 1

select distinct extract(year from re.rental_date) as "Год проката"
  from RENTAL re
 order by 1

select distinct p.amount as "Платеж"
  from PAYMENT p
 where p.amount > 0
 order by 1

select f.title as "Название фильма",
       f.rental_rate as "Стоимость фильма",
       f.replacement_cost as "Стоимость залога фильма",
       f.length as "Продолжительность фильма",
       f.description as "Сюжет фильма",
       f.rating as "Возрастной рейтинг",
       f.release_year as "Год выхода фильма",
       f.special_features as "Дополнительные материалы фильма",
       f.rental_duration as "Срок возврата фильма"
  from FILM f
 where f.title = 'На мосту'
 order by 1

select f.title as "Фильм",
       f.release_year as "Год выхода фильма"
  from FILM f
 order by 2

select distinct concat(s.first_name, ' ', s.last_name) as "Сотрудник"
  from STAFF s
 where upper(s.first_name) = 'МИХАИЛ'
 order by 1

select distinct a.last_name as "Фамилия актера"
  from ACTOR a
 where replace(upper(a.first_name), 'Ё', 'Е') = 'АНДРЕЙ'
 order by 1

select distinct ca.category_id as "Идентификатор категории"
  from CATEGORY ca
 order by 1

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент"
  from CUSTOMER c
 where upper(c.first_name) = 'ЯН'
   and upper(c.last_name) = 'СПИВАКОВ'
 order by 1

select distinct f.rating as "Возрастной рейтинг"
  from FILM f
 order by 1

select f.title as "Название фильма",
       f.description as "Сюжет фильма"
  from FILM f
 order by 1

select sum(p.amount) as "Сумма платежей"
  from PAYMENT p
 where p.payment_date between '2022-01-01 00:00:00' and '2025-12-31 23:59:59'

select sum(p.amount) as "Сумма платежей"
  from PAYMENT p
 where p.payment_date between '2022-01-01 00:00:00' and '2025-12-31 23:59:59'

Результат не совпадает с эталоном

select c.first_name as "Имя клиента",
       c.last_name as "Фамилия клиента",
       ad.address as "Адрес",
       ci.city as "Город",
       co.country as "Страна"
  from CUSTOMER c
  join ADDRESS ad on c.address_id = ad.address_id
  join CITY ci on ad.city_id = ci.city_id
  join COUNTRY co on ci.country_id = co.country_id
 order by 1

select c.first_name as "Имя клиента",
       c.last_name as "Фамилия клиента"
  from CUSTOMER c
 where upper(c.first_name) like 'КОС%'
   and exists (select *
       from PAYMENT p
      where p.customer_id = c.customer_id
        and p.payment_date between '2007-04-30 00:00:00' and '2007-04-30 23:59:59'
        and p.amount > 10)
 order by 2, 1 desc nulls last

select distinct f.title as "Фильм",
       ca.name as "Категория"
  from FILM f
  join FILM_CATEGORY fc on fc.film_id = f.film_id
  join CATEGORY ca on fc.category_id = ca.category_id
 order by 1

select distinct f.title as "Фильм",
       ca.name as "Категория"
  from CATEGORY ca
  join FILM_CATEGORY fc on fc.category_id = ca.category_id
  join FILM f on fc.film_id = f.film_id
 where ca.category_id in (3, 12)
 order by 1

select distinct f.title as "Фильм",
       ca.name as "Категория"
  from CATEGORY ca
  join FILM_CATEGORY fc on fc.category_id = ca.category_id
  join FILM f on fc.film_id = f.film_id
 where ca.category_id in (8, 9, 10)
 order by 1

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент"
  from CUSTOMER c
 where exists (select *
       from RENTAL re
      where re.customer_id = c.customer_id
        and re.return_date is null
        and re.rental_date between '2005-01-01 00:00:00' and '2005-12-31 23:59:59')
 order by 1

select distinct ad.address as "Адрес"
  from ADDRESS ad
 where exists (select *
       from STORE st
       join CITY ci on ad.city_id = ci.city_id
      where st.address_id = ad.address_id
        and replace(upper(ci.city), 'Ё', 'Е') in ('УРЮПИНСКЕ', 'УРЮПИНСК', 'МОСКВА'))
 order by 1

select distinct (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад"
  from STORE st
 where exists (select *
       from ADDRESS ad
       join CITY ci on ad.city_id = ci.city_id
       join COUNTRY co on ci.country_id = co.country_id
      where st.address_id = ad.address_id
        and co.country = 'Россия')
 order by 1

select distinct la.name as "Язык озвучки"
  from LANGUAGE la
 where exists (select *
       from FILM f
       join INVENTORY iv on iv.film_id = f.film_id
      where f.language_id = la.language_id
        and not exists
          (select *
            from RENTAL ren
           where ren.inventory_id = iv.inventory_id
             and ren.return_date is null
           )
        and replace(upper(f.title), 'Ё', 'Е') = 'ЗАВОДНОЙ АПЕЛЬСИН')
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where exists (select *
       from INVENTORY iv
       join RENTAL re on re.inventory_id = iv.inventory_id
      where iv.film_id = f.film_id
        and re.return_date is null)
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where exists (select *
       from INVENTORY iv
       join RENTAL re on re.inventory_id = iv.inventory_id
      where iv.film_id = f.film_id
        and re.return_date is null)
 order by 1

select distinct f.title as "Фильм",
       la.name as "Название языка озвучки"
  from FILM f
  join LANGUAGE la on f.language_id = la.language_id
 where la.language_id != 1
 order by 1

select distinct (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад"
  from STORE st
 where exists (select *
       from ADDRESS ad
       join INVENTORY iv on iv.store_id = st.store_id
       join CITY ci on ad.city_id = ci.city_id
       join RENTAL re on re.inventory_id = iv.inventory_id
       join COUNTRY co on ci.country_id = co.country_id
      where st.address_id = ad.address_id
        and co.country = 'Австралия')
 order by 1

select distinct f.title as "Фильм",
       ca.name as "Категория"
  from CATEGORY ca
  join FILM_CATEGORY fc on fc.category_id = ca.category_id
  join FILM f on fc.film_id = f.film_id
  join INVENTORY iv on iv.film_id = f.film_id
  join RENTAL re on re.inventory_id = iv.inventory_id
 where ca.category_id in (11, 5)
   and re.return_date is null
 order by 1

select count(f.film_id) as "Количество фильмов"
  from FILM f
 where f.rating = 'NC-17'
   and length(f.title) < 19
   and exists (select *
       from INVENTORY iv
       join RENTAL re on re.inventory_id = iv.inventory_id
      where iv.film_id = f.film_id
        and date_part('day', re.return_date - re.rental_date) > 10
        and re.return_date is not null)

select distinct c.first_name as "Имя клиента"
  from CUSTOMER c
 where exists (select *
       from RENTAL re
       join INVENTORY iv on re.inventory_id = iv.inventory_id
       join FILM f on iv.film_id = f.film_id
       join LANGUAGE la on f.language_id = la.language_id
      where re.customer_id = c.customer_id
        and f.release_year > 2001
        and la.language_id = 6
        and f.replacement_cost > 100)
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where f.release_year = 2007
   and exists (select *
       from FILM_ACTOR fa
       join ACTOR a on fa.actor_id = a.actor_id
      where fa.film_id = f.film_id
        and upper(a.first_name) = 'МУ'
        and upper(a.last_name) = 'ПУК')
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where exists (select *
       from FILM_ACTOR fa
       join ACTOR a on fa.actor_id = a.actor_id
      where fa.film_id = f.film_id
        and upper(a.first_name) = 'ДЖОННИ'
        and replace(upper(a.last_name), 'Ё', 'Е') = 'ДЕПП')
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where exists (select *
       from FILM_ACTOR fa
       join ACTOR a on fa.actor_id = a.actor_id
      where fa.film_id = f.film_id
        and replace(upper(a.last_name), 'Ё', 'Е') = 'ПЕТРОВ'
        and replace(upper(a.first_name), 'Ё', 'Е') = 'АНДРЕЙ')
 order by 1

select distinct f.title as "Фильм"
  from RENTAL re
  join STAFF s on re.staff_id = s.staff_id
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
 where upper(s.first_name) = 'ВАСЯ'
 order by 1

select c.first_name as "Имя клиента",
       c.last_name as "Фамилия клиента",
       ad.address as "Адрес"
  from CUSTOMER c
  join ADDRESS ad on c.address_id = ad.address_id
  join RENTAL re on re.customer_id = c.customer_id
  join PAYMENT p on p.rental_id = re.rental_id
  join CITY ci on ad.city_id = ci.city_id
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
  join FILM_CATEGORY fc on fc.film_id = f.film_id
  join CATEGORY ca on fc.category_id = ca.category_id
 where ca.category_id = 5
   and re.rental_date between '2006-01-01 00:00:00' and '2006-12-31 23:59:59'
   and ci.city = 'Москва'
   and date_part('day', p.payment_date - re.rental_date) <= 14
 order by 1

select distinct f.title as "Фильм"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
 order by 1

select distinct f.title as "Фильм"
  from FILM f
 where exists (select *
       from INVENTORY iv
       join RENTAL re on re.inventory_id = iv.inventory_id
      where iv.film_id = f.film_id)
 order by 1

select count(iv.inventory_id) as "Количество фильмов на складе"
  from INVENTORY iv
 where not exists (select *
       from RENTAL ren
      where ren.inventory_id = iv.inventory_id
        and ren.return_date is null)
   and exists (select *
       from FILM f
      where iv.film_id = f.film_id)

select distinct f.title as "Фильм"
  from FILM f
 where exists (select *
       from INVENTORY iv
       join STORE st on iv.store_id = st.store_id
      where iv.film_id = f.film_id)
   and not exists (select *
       from INVENTORY iv
       join STORE st on iv.store_id = st.store_id
      where iv.film_id = f.film_id
        and exists
          (select *
            from RENTAL ren
           where ren.inventory_id = iv.inventory_id
             and ren.return_date is null
           ))
 order by 1

select c.email as "Email клиента",
       (select min(rre.rental_date)
       from RENTAL rre
      where rre.customer_id = c.customer_id) as "Дата прихода клиента"
  from CUSTOMER c
 where (select min(rre.rental_date)
       from RENTAL rre
      where rre.customer_id = c.customer_id) between '2025-03-01 00:00:00' and '2025-06-30 23:59:59'
 order by 1

Результат не совпадает с эталоном

select distinct (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад"
  from STORE st
 where exists (select *
       from INVENTORY iv
       join RENTAL re on re.inventory_id = iv.inventory_id
       join FILM f on iv.film_id = f.film_id
      where iv.store_id = st.store_id
        and f.title = 'Хостел')
 order by 1

select distinct ci.city as "Город"
  from CITY ci
 where exists (select *
       from COUNTRY co
      where ci.country_id = co.country_id
        and ci.city = co.country)
 order by 1

select distinct concat(a.first_name, ' ', a.last_name) as "Актер"
  from CATEGORY ca
  join FILM_CATEGORY fc on fc.category_id = ca.category_id
  join FILM f on fc.film_id = f.film_id
  join FILM_ACTOR fa on fa.film_id = f.film_id
  join ACTOR a on fa.actor_id = a.actor_id
 where ca.category_id = 9
 order by 1

select distinct re.rental_date as "Дата начала аренды"
  from RENTAL re
 where exists (select *
       from CUSTOMER c
       join INVENTORY iv on re.inventory_id = iv.inventory_id
       join FILM f on iv.film_id = f.film_id
      where re.customer_id = c.customer_id
        and upper(c.first_name) = 'ЯКУБ'
        and replace(upper(c.last_name), 'Ё', 'Е') = 'ДЕМИН'
        and f.title = 'Клерки')
 order by 1

select distinct concat(s.first_name, ' ', s.last_name) as "Сотрудник"
  from STAFF s
 where exists (select *
       from ADDRESS ad
       join STORE st on s.store_id = st.store_id
      where ad.address = 'Четвертая (Венера тер. СНТ), дом 141')
 order by 1

select distinct (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад"
  from STAFF s
  join STORE st on s.store_id = st.store_id
 where replace(upper(s.first_name), 'Ё', 'Е') = 'АЛЕКСАНДР'
   and upper(s.last_name) = 'ИВАНОВ'
 order by 1

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент"
  from CUSTOMER c
 where exists (select *
       from RENTAL re
       join INVENTORY iv on re.inventory_id = iv.inventory_id
       join FILM f on iv.film_id = f.film_id
       join FILM_ACTOR fa on fa.film_id = f.film_id
       join ACTOR a on fa.actor_id = a.actor_id
      where re.customer_id = c.customer_id
        and substr(a.first_name, 1, 1) = substr(c.first_name, 1, 1))
 order by 1

select distinct concat(s.first_name, ' ', s.last_name) as "Сотрудник",
       (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад"
  from STORE st
  join STAFF s on st.manager_staff_id = s.staff_id
 order by 1

select distinct concat(s.first_name, ' ', s.last_name) as "Сотрудник",
       ad.address as "Адрес"
  from STORE st
  join STAFF s on st.manager_staff_id = s.staff_id
  join ADDRESS ad on st.address_id = ad.address_id
 order by 1

select distinct concat(s.first_name, ' ', s.last_name) as "Сотрудник",
       ad.address as "Адрес",
       ci.city as "Город"
  from STORE st
  join STAFF s on st.manager_staff_id = s.staff_id
  join ADDRESS ad on st.address_id = ad.address_id
  join CITY ci on ad.city_id = ci.city_id
 order by 1

select distinct f.title as "Фильм"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join CUSTOMER c on re.customer_id = c.customer_id
  join FILM f on iv.film_id = f.film_id
 where upper(c.first_name) = 'ЯН'
   and upper(c.last_name) = 'СПИВАКОВ'
   and f.title = 'Извращенная страсть'
 order by 1

select distinct ad.address as "Адрес",
       (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад"
  from ADDRESS ad
  join STORE st on st.address_id = ad.address_id
 order by 1

select distinct (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад"
  from STORE st
 where exists (select *
       from STAFF s
      where s.store_id = st.store_id
        and upper(s.first_name) = 'ЯН')
 order by 1

select distinct ci.city as "Город",
       ad.address as "Адрес"
  from CITY ci
  join ADDRESS ad on ad.city_id = ci.city_id
  join STORE st on st.address_id = ad.address_id
 order by 1

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       (select date_part('day', coalesce(re.return_date, current_timestamp) - re.rental_date)
       from RENTAL re
      where re.customer_id = c.customer_id
        and re.rental_date <= '2025-06-19 00:00:00'
        and coalesce(re.return_date, current_timestamp) >= '2025-06-19 23:59:59'
        and re.return_date is null
      limit 1) as "Дней в аренде"
  from CUSTOMER c
 where exists (select *
       from RENTAL re
      where re.customer_id = c.customer_id
        and re.rental_date <= '2025-06-19 00:00:00'
        and coalesce(re.return_date, current_timestamp) >= '2025-06-19 23:59:59'
        and re.return_date is null)
 order by 1

Результат не совпадает с эталоном

select distinct date_part('day', re.return_date - re.rental_date) - f.rental_duration as "Число дней задержки возврата фильма"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join CUSTOMER c on re.customer_id = c.customer_id
  join FILM f on iv.film_id = f.film_id
 where f.title = 'Воин'
   and upper(c.last_name) = 'СИДОРОВ'
   and (re.return_date is not null and date_part('day', re.return_date - re.rental_date) > f.rental_duration)
 order by 1

select count(re.rental_id) as "Количество прокатов"
  from RENTAL re
 where date_part('day', coalesce(re.return_date, current_timestamp) - re.rental_date) > 30
   and re.return_date is null

select la.name as "Язык озвучки",
       count(distinct f.film_id) as "Количество фильмов"
  from LANGUAGE la
  left join FILM f on f.language_id = la.language_id
 group by la.language_id
 order by 2 desc nulls last, 1

select la.name as "Язык озвучки",
       count(distinct f.film_id) as "Количество фильмов"
  from LANGUAGE la
  left join FILM f on f.language_id = la.language_id
 group by la.language_id
 order by 1 desc nulls last

select extract(year from p.payment_date) as "Год платежа",
       date_trunc('month', p.payment_date) as "Месяц с годом платежа",
       date(p.payment_date) as "Дата платежа",
       sum(p.amount) as "Сумма платежей"
  from PAYMENT p
 where p.payment_date between '2005-01-01 00:00:00' and '2005-12-31 23:59:59'
 group by 1, 2, 3
 order by 1, 2, 3

select extract(year from p.payment_date) as "Год платежа",
       date_trunc('month', p.payment_date) as "Месяц с годом платежа",
       date(p.payment_date) as "Дата платежа",
       sum(p.amount) as "Сумма платежей"
  from PAYMENT p
 group by 1, 2, 3
 order by 1, 2, 3

select co.country as "Страна",
       count(distinct ci.city_id) as "Количество городов",
       count(distinct c.customer_id) as "Количество клиентов"
  from COUNTRY co
  left join CITY ci on ci.country_id = co.country_id
  left join ADDRESS ad on ad.city_id = ci.city_id
  left join CUSTOMER c on c.address_id = ad.address_id
 group by co.country_id
 order by 3 desc nulls last, 2 desc nulls last

select ca.name as "Категория",
       f.rating as "Возрастной рейтинг",
       count(distinct f.film_id) as "Количество фильмов"
  from FILM f
  left join FILM_CATEGORY fc on fc.film_id = f.film_id
  left join CATEGORY ca on fc.category_id = ca.category_id
 group by ca.category_id, 2
 order by 1, 2

select distinct f.title as "Фильм",
       f.rental_rate as "Стоимость фильма"
  from FILM f
  join FILM_CATEGORY fc on fc.film_id = f.film_id
  join CATEGORY ca on fc.category_id = ca.category_id
 where ca.category_id = 3
   and f.rental_rate = (select min(f.rental_rate)
       from FILM f
       join FILM_CATEGORY fc on fc.film_id = f.film_id
       join CATEGORY ca on fc.category_id = ca.category_id
      where ca.category_id = 3)
 order by 1

select f.title as "Название фильма",
       count(distinct re.rental_id) as "Количество прокатов"
  from FILM f
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 group by 1
 order by 2 desc nulls last

select f.title as "Фильм",
       extract(year from re.rental_date) as "Год проката",
       count(distinct re.rental_id) as "Количество прокатов"
  from FILM f
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 group by f.film_id, 2
 order by 1, 2

select f.title as "Фильм",
       count(distinct la.language_id) as "Количество языков озвучки"
  from FILM f
  join LANGUAGE la on f.language_id = la.language_id
 group by f.film_id
 order by 2 desc nulls last, 1

select f.title as "Название фильма",
       count(distinct re.rental_id) as "Популярность проката"
  from FILM f
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 group by 1
 order by 2 desc nulls last

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       count(distinct re.rental_id) as "Количество прокатов"
  from CUSTOMER c
  left join RENTAL re on re.customer_id = c.customer_id
 where re.return_date is null
   and re.rental_date between '2004-01-01 00:00:00' and '2004-12-31 23:59:59'
 group by c.customer_id
 order by 2

select avg(date_part('day', re.return_date - re.rental_date)) as "Среднее количество дней проката"
  from RENTAL re
 where re.rental_date between '2025-05-01 00:00:00' and '2025-05-31 23:59:59'
   and re.return_date is not null
   and exists (select *
       from INVENTORY iv
       join FILM f on iv.film_id = f.film_id
      where re.inventory_id = iv.inventory_id)

Результат не совпадает с эталоном

select f.title as "Фильм",
       sum(p.amount) as "Сумма величин платежа"
  from FILM f
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
  left join PAYMENT p on p.rental_id = re.rental_id
 group by f.film_id
 order by 2 desc nulls last, 1

select count(f.film_id) as "Количество фильмов"
  from FILM f
 where exists (select *
       from FILM_CATEGORY fc
       join INVENTORY iv on iv.film_id = f.film_id
       join CATEGORY ca on fc.category_id = ca.category_id
       join RENTAL re on re.inventory_id = iv.inventory_id
      where fc.film_id = f.film_id
        and ca.category_id in (5, 6)
        and date_part('day', coalesce(re.return_date, current_timestamp) - re.rental_date) > f.rental_duration
        and re.rental_date between '2006-01-01 00:00:00' and '2006-12-31 23:59:59')

select (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад",
       count(distinct c.customer_id) as "Количество клиентов"
  from STORE st
  left join INVENTORY iv on iv.store_id = st.store_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
  left join CUSTOMER c on re.customer_id = c.customer_id
 group by st.store_id
 order by 2 desc nulls last, 1

select date_trunc('month', re.rental_date) as "Месяц с годом проката",
       avg((select ffi.rental_rate
       from FILM ffi
       join INVENTORY iinv on iinv.film_id = ffi.film_id
      where iinv.inventory_id = re.inventory_id)) as "Средняя стоимость проката"
  from RENTAL re
 where re.rental_date between '2006-01-01 00:00:00' and '2006-12-31 23:59:59'
 group by 1
 order by 1

select concat(a.first_name, ' ', a.last_name) as "Актер",
       count(distinct f.film_id) as "Количество игр актёра в фильме"
  from ACTOR a
  left join FILM_ACTOR fa on fa.actor_id = a.actor_id
  left join FILM f on fa.film_id = f.film_id
 group by a.actor_id
 order by 2 desc nulls last, 1

select concat(a.first_name, ' ', a.last_name) as "Актер",
       count(distinct f.film_id) as "Количество игр актёра в фильме"
  from ACTOR a
  left join FILM_ACTOR fa on fa.actor_id = a.actor_id
  left join FILM f on fa.film_id = f.film_id
 group by a.actor_id
 order by 2 desc nulls last, 1

select f.title as "Фильм",
       count(distinct re.rental_id) as "Популярность проката"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
 group by f.film_id
 order by 2 desc nulls last

select ca.name as "Категория",
       avg(p.amount) as "Средняя величина платежа"
  from CATEGORY ca
  left join FILM_CATEGORY fc on fc.category_id = ca.category_id
  left join FILM f on fc.film_id = f.film_id
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
  left join PAYMENT p on p.rental_id = re.rental_id
 group by ca.category_id
 order by 1

select date_trunc('month', re.rental_date) as "Месяц с годом проката",
       avg((select ffi.rental_rate
       from FILM ffi
       join INVENTORY iinv on iinv.film_id = ffi.film_id
      where iinv.inventory_id = re.inventory_id)) as "Средняя стоимость проката"
  from RENTAL re
 where re.rental_date between '2006-01-01 00:00:00' and '2006-12-31 23:59:59'
 group by 1
 order by 1

select ci.city as "Город",
       count(distinct c.customer_id) as "Количество клиентов"
  from CITY ci
  left join ADDRESS ad on ad.city_id = ci.city_id
  left join CUSTOMER c on c.address_id = ad.address_id
  left join RENTAL re on re.customer_id = c.customer_id
 where re.rental_date between '1995-01-01 00:00:00' and '2025-12-31 23:59:59'
 group by ci.city_id
 order by 2 desc nulls last, 1

Результат не совпадает с эталоном

select concat(s.first_name, ' ', s.last_name) as "Сотрудник",
       count(distinct c.customer_id) as "Количество клиентов"
  from STAFF s
  left join RENTAL re on re.staff_id = s.staff_id
  left join CUSTOMER c on re.customer_id = c.customer_id
 group by s.staff_id
 order by 2 desc nulls last, 1

select date(re.return_date) as "Дата проката",
       count(re.rental_id) as "Количество прокатов"
  from RENTAL re
 where re.return_date is not null
 group by 1
 order by 1

select date(p.payment_date) as "Дата платежа",
       sum(p.amount) as "Сумма платежей"
  from PAYMENT p
 group by 1
 order by 1

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       sum(p.amount) as "Сумма платежей"
  from CUSTOMER c
  left join PAYMENT p on p.customer_id = c.customer_id
 group by c.customer_id
 order by 2 desc nulls last, 1

select ca.name as "Категория",
       count(distinct re.rental_id) as "Популярность проката"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
  left join FILM_CATEGORY fc on fc.film_id = f.film_id
  left join CATEGORY ca on fc.category_id = ca.category_id
 group by ca.category_id
 order by 2 desc nulls last

select ca.name as "Категория",
       count(distinct re.rental_id) as "Популярность проката"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
  left join FILM_CATEGORY fc on fc.film_id = f.film_id
  left join CATEGORY ca on fc.category_id = ca.category_id
 group by ca.category_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select ca.name as "Категория",
                 count(distinct re.rental_id) as tmpval
            from RENTAL re
            join INVENTORY iv on re.inventory_id = iv.inventory_id
            join FILM f on iv.film_id = f.film_id
            left join FILM_CATEGORY fc on fc.film_id = f.film_id
            left join CATEGORY ca on fc.category_id = ca.category_id
           group by ca.category_id
             ) tmpsel)
 order by 1

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       count(distinct re.rental_id) as "Количество прокатов"
  from CUSTOMER c
  join ADDRESS ad on c.address_id = ad.address_id
  left join RENTAL re on re.customer_id = c.customer_id
  left join CITY ci on ad.city_id = ci.city_id
  left join INVENTORY iv on re.inventory_id = iv.inventory_id
  left join FILM f on iv.film_id = f.film_id
 where ci.city = 'Астрахань'
   and re.return_date is not null
   and date_part('day', re.return_date - re.rental_date) > f.rental_duration
   and (re.return_date is not null and date_part('day', re.return_date - re.rental_date) > f.rental_duration)
 group by c.customer_id
 order by 2 desc nulls last

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       count(distinct re.rental_id) as "Количество прокатов"
  from CUSTOMER c
  join ADDRESS ad on c.address_id = ad.address_id
  left join RENTAL re on re.customer_id = c.customer_id
  left join CITY ci on ad.city_id = ci.city_id
  left join INVENTORY iv on re.inventory_id = iv.inventory_id
  left join FILM f on iv.film_id = f.film_id
 where ci.city = 'Астрахань'
   and re.return_date is not null
   and date_part('day', re.return_date - re.rental_date) > f.rental_duration
   and (re.return_date is not null and date_part('day', re.return_date - re.rental_date) > f.rental_duration)
 group by c.customer_id
 order by 2 desc nulls last, 1

select ad.district as "Район адреса",
       count(distinct re.rental_id) as "Популярность проката"
  from ADDRESS ad
  left join CUSTOMER c on c.address_id = ad.address_id
  left join RENTAL re on re.customer_id = c.customer_id
  left join INVENTORY iv on re.inventory_id = iv.inventory_id
  left join FILM f on iv.film_id = f.film_id
 where f.title = 'Корова'
 group by 1
 order by 2 desc nulls last, 1

select ci.city as "Город",
       sum(p.amount) as "Сумма платежей"
  from CITY ci
  left join ADDRESS ad on ad.city_id = ci.city_id
  left join STORE st on st.address_id = ad.address_id
  left join INVENTORY iv on iv.store_id = st.store_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
  left join PAYMENT p on p.rental_id = re.rental_id
 group by ci.city_id
 order by 2 desc nulls last, 1

select avg(atab.tmpval) as "Среднее количество разных районов адреса" from (
     select ci.city as "Город",
            count(distinct ad.district) as tmpval
       from CITY ci
       left join ADDRESS ad on ad.city_id = ci.city_id
      group by ci.city_id
      order by 2 desc nulls last, 1
        ) atab

select count(re.rental_id) as "Количество прокатов"
  from RENTAL re
 where re.return_date is null

select avg(atab.tmpval) as "Средняя сумма платежей" from (
     select date_trunc('month', p.payment_date) as "Месяц с годом платежа",
            sum(p.amount) as tmpval
       from PAYMENT p
      group by 1
      order by 1
        ) atab

select ci.city as "Город",
       count(distinct re.rental_id) as "Количество прокатов"
  from CITY ci
  left join ADDRESS ad on ad.city_id = ci.city_id
  left join CUSTOMER c on c.address_id = ad.address_id
  left join RENTAL re on re.customer_id = c.customer_id
  left join INVENTORY iv on re.inventory_id = iv.inventory_id
  left join FILM f on iv.film_id = f.film_id
  left join FILM_CATEGORY fc on fc.film_id = f.film_id
  left join CATEGORY ca on fc.category_id = ca.category_id
 where ca.category_id = 11
 group by ci.city_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select ci.city as "Город",
                 count(distinct re.rental_id) as tmpval
            from CITY ci
            left join ADDRESS ad on ad.city_id = ci.city_id
            left join CUSTOMER c on c.address_id = ad.address_id
            left join RENTAL re on re.customer_id = c.customer_id
            left join INVENTORY iv on re.inventory_id = iv.inventory_id
            left join FILM f on iv.film_id = f.film_id
            left join FILM_CATEGORY fc on fc.film_id = f.film_id
            left join CATEGORY ca on fc.category_id = ca.category_id
           where ca.category_id = 11
           group by ci.city_id
             ) tmpsel)
 order by 1

select ad.district as "Район адреса",
       count(distinct re.rental_id) as "Количество прокатов"
  from ADDRESS ad
  left join STORE st on st.address_id = ad.address_id
  left join INVENTORY iv on iv.store_id = st.store_id
  left join FILM f on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 where ad.district not in ('Татарстан Респ', 'Московская обл')
   and f.title = 'Корова'
 group by 1
having count(distinct re.rental_id) = (select max(tmpval) from (
          select ad.district as "Район адреса",
                 count(distinct re.rental_id) as tmpval
            from ADDRESS ad
            left join STORE st on st.address_id = ad.address_id
            left join INVENTORY iv on iv.store_id = st.store_id
            left join FILM f on iv.film_id = f.film_id
            left join RENTAL re on re.inventory_id = iv.inventory_id
           where ad.district not in ('Татарстан Респ', 'Московская обл')
             and f.title = 'Корова'
           group by 1
             ) tmpsel)
 order by 1

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       count(distinct re.rental_id) as "Количество прокатов"
  from CUSTOMER c
  left join RENTAL re on re.customer_id = c.customer_id
  left join INVENTORY iv on re.inventory_id = iv.inventory_id
  left join FILM f on iv.film_id = f.film_id
 where date_part('day', coalesce(re.return_date, current_timestamp) - re.rental_date) > f.rental_duration
   and (replace(upper(c.first_name), 'Ё', 'Е') != 'ЕГОР' or upper(c.last_name) != 'МАКАРОВ')
   and (upper(c.first_name) != 'СВЯТОСЛАВ' or replace(upper(c.last_name), 'Ё', 'Е') != 'ГРЕКОВ')
 group by c.customer_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select concat(c.first_name, ' ', c.last_name) as "Клиент",
                 count(distinct re.rental_id) as tmpval
            from CUSTOMER c
            left join RENTAL re on re.customer_id = c.customer_id
            left join INVENTORY iv on re.inventory_id = iv.inventory_id
            left join FILM f on iv.film_id = f.film_id
           where date_part('day', coalesce(re.return_date, current_timestamp) - re.rental_date) > f.rental_duration
             and (replace(upper(c.first_name), 'Ё', 'Е') != 'ЕГОР' or upper(c.last_name) != 'МАКАРОВ')
             and (upper(c.first_name) != 'СВЯТОСЛАВ' or replace(upper(c.last_name), 'Ё', 'Е') != 'ГРЕКОВ')
           group by c.customer_id
             ) tmpsel)
 order by 1

select ad.address as "Адрес",
       count(distinct s.staff_id) as "Количество сотрудников"
  from ADDRESS ad
  left join STORE st on st.address_id = ad.address_id
  left join STAFF s on s.store_id = st.store_id
 group by ad.address_id
having count(distinct s.staff_id) = (select max(tmpval) from (
          select ad.address as "Адрес",
                 count(distinct s.staff_id) as tmpval
            from ADDRESS ad
            left join STORE st on st.address_id = ad.address_id
            left join STAFF s on s.store_id = st.store_id
           group by ad.address_id
             ) tmpsel)
 order by 1

select (select aa.address
       from ADDRESS aa
      where aa.address_id = st.address_id) as "Склад",
       count(distinct re.rental_id) as "Количество прокатов"
  from STORE st
  join ADDRESS ad on st.address_id = ad.address_id
  left join INVENTORY iv on iv.store_id = st.store_id
  left join CITY ci on ad.city_id = ci.city_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
  left join FILM f on iv.film_id = f.film_id
  left join FILM_CATEGORY fc on fc.film_id = f.film_id
  left join CATEGORY ca on fc.category_id = ca.category_id
 where ci.city = 'Москва'
   and ca.category_id = 12
   and re.rental_date between '1950-01-01 00:00:00' and '2014-06-13 23:59:59'
 group by st.store_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select (select aa.address
                 from ADDRESS aa
                where aa.address_id = st.address_id) as "Склад",
                 count(distinct re.rental_id) as tmpval
            from STORE st
            join ADDRESS ad on st.address_id = ad.address_id
            left join INVENTORY iv on iv.store_id = st.store_id
            left join CITY ci on ad.city_id = ci.city_id
            left join RENTAL re on re.inventory_id = iv.inventory_id
            left join FILM f on iv.film_id = f.film_id
            left join FILM_CATEGORY fc on fc.film_id = f.film_id
            left join CATEGORY ca on fc.category_id = ca.category_id
           where ci.city = 'Москва'
             and ca.category_id = 12
             and re.rental_date between '1950-01-01 00:00:00' and '2014-06-13 23:59:59'
           group by st.store_id
             ) tmpsel)
 order by 1

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       count(distinct re.rental_id) as "Количество прокатов"
  from CUSTOMER c
  left join RENTAL re on re.customer_id = c.customer_id
 where re.return_date is null
   and re.rental_date <= '2025-06-20 14:16:22'
   and coalesce(re.return_date, current_timestamp) >= '2025-06-20 14:16:22'
 group by c.customer_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select concat(c.first_name, ' ', c.last_name) as "Клиент",
                 count(distinct re.rental_id) as tmpval
            from CUSTOMER c
            left join RENTAL re on re.customer_id = c.customer_id
           where re.return_date is null
             and re.rental_date <= '2025-06-20 14:16:22'
             and coalesce(re.return_date, current_timestamp) >= '2025-06-20 14:16:22'
           group by c.customer_id
             ) tmpsel)
 order by 1

Результат не совпадает с эталоном

select f.title as "Фильм",
       count(distinct re.rental_id) as "Количество прокатов"
  from FILM f
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 group by f.film_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select f.title as "Фильм",
                 count(distinct re.rental_id) as tmpval
            from FILM f
            left join INVENTORY iv on iv.film_id = f.film_id
            left join RENTAL re on re.inventory_id = iv.inventory_id
           group by f.film_id
             ) tmpsel)
 order by 1

select date(re.rental_date) as "Дата проката",
       count(distinct re.rental_id) as "Количество прокатов"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
  join FILM_CATEGORY fc on fc.film_id = f.film_id
  join CATEGORY ca on fc.category_id = ca.category_id
 where ca.category_id = 5
 group by 1
having count(distinct re.rental_id) = (select max(tmpval) from (
          select date(re.rental_date) as "Дата проката",
                 count(distinct re.rental_id) as tmpval
            from RENTAL re
            join INVENTORY iv on re.inventory_id = iv.inventory_id
            join FILM f on iv.film_id = f.film_id
            join FILM_CATEGORY fc on fc.film_id = f.film_id
            join CATEGORY ca on fc.category_id = ca.category_id
           where ca.category_id = 5
           group by 1
           order by 1
             ) tmpsel)
 order by 1

select ca.name as "Категория",
       count(distinct re.rental_id) as "Количество прокатов"
  from CATEGORY ca
  left join FILM_CATEGORY fc on fc.category_id = ca.category_id
  left join FILM f on fc.film_id = f.film_id
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 group by ca.category_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select ca.name as "Категория",
                 count(distinct re.rental_id) as tmpval
            from CATEGORY ca
            left join FILM_CATEGORY fc on fc.category_id = ca.category_id
            left join FILM f on fc.film_id = f.film_id
            left join INVENTORY iv on iv.film_id = f.film_id
            left join RENTAL re on re.inventory_id = iv.inventory_id
           group by ca.category_id
             ) tmpsel)
 order by 1

select f.title as "Фильм",
       count(distinct re.rental_id) as "Популярность проката"
  from RENTAL re
  join INVENTORY iv on re.inventory_id = iv.inventory_id
  join FILM f on iv.film_id = f.film_id
 group by f.film_id
having count(distinct re.rental_id) = (select min(tmpval) from (
          select f.title as "Фильм",
                 count(distinct re.rental_id) as tmpval
            from RENTAL re
            join INVENTORY iv on re.inventory_id = iv.inventory_id
            join FILM f on iv.film_id = f.film_id
           group by f.film_id
             ) tmpsel)
 order by 1

select concat(c.first_name, ' ', c.last_name) as "Клиент",
       count(distinct re.rental_id) as "Количество прокатов"
  from CUSTOMER c
  left join RENTAL re on re.customer_id = c.customer_id
  left join INVENTORY iv on re.inventory_id = iv.inventory_id
  left join FILM f on iv.film_id = f.film_id
 where (replace(upper(c.first_name), 'Ё', 'Е') != 'ЕГОР' or upper(c.last_name) != 'МАКАРОВ')
   and date_part('day', coalesce(re.return_date, current_timestamp) - re.rental_date) > f.rental_duration
 group by c.customer_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select concat(c.first_name, ' ', c.last_name) as "Клиент",
                 count(distinct re.rental_id) as tmpval
            from CUSTOMER c
            left join RENTAL re on re.customer_id = c.customer_id
            left join INVENTORY iv on re.inventory_id = iv.inventory_id
            left join FILM f on iv.film_id = f.film_id
           where (replace(upper(c.first_name), 'Ё', 'Е') != 'ЕГОР' or upper(c.last_name) != 'МАКАРОВ')
             and date_part('day', coalesce(re.return_date, current_timestamp) - re.rental_date) > f.rental_duration
           group by c.customer_id
             ) tmpsel)
 order by 1

select ad.district as "Район адреса",
       count(distinct re.rental_id) as "Количество прокатов"
  from ADDRESS ad
  left join STORE st on st.address_id = ad.address_id
  left join INVENTORY iv on iv.store_id = st.store_id
  left join FILM f on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 where f.title = 'Корова'
 group by 1
having count(distinct re.rental_id) = (select max(tmpval) from (
          select ad.district as "Район адреса",
                 count(distinct re.rental_id) as tmpval
            from ADDRESS ad
            left join STORE st on st.address_id = ad.address_id
            left join INVENTORY iv on iv.store_id = st.store_id
            left join FILM f on iv.film_id = f.film_id
            left join RENTAL re on re.inventory_id = iv.inventory_id
           where f.title = 'Корова'
           group by 1
             ) tmpsel)
 order by 1

select ci.city as "Город",
       count(distinct re.rental_id) as "Количество прокатов"
  from CITY ci
  left join ADDRESS ad on ad.city_id = ci.city_id
  left join CUSTOMER c on c.address_id = ad.address_id
  left join RENTAL re on re.customer_id = c.customer_id
 where re.rental_date between '2006-01-01 00:00:00' and '2006-12-31 23:59:59'
 group by ci.city_id
having count(distinct re.rental_id) = (select max(tmpval) from (
          select ci.city as "Город",
                 count(distinct re.rental_id) as tmpval
            from CITY ci
            left join ADDRESS ad on ad.city_id = ci.city_id
            left join CUSTOMER c on c.address_id = ad.address_id
            left join RENTAL re on re.customer_id = c.customer_id
           where re.rental_date between '2006-01-01 00:00:00' and '2006-12-31 23:59:59'
           group by ci.city_id
             ) tmpsel)
 order by 1

select ad.district as "Район адреса",
       ad.address as "Адрес",
       st.store_id as "Идентификатор склада",
       count(distinct re.rental_id) as "Количество прокатов"
  from ADDRESS ad
  left join STORE st on st.address_id = ad.address_id
  left join INVENTORY iv on iv.store_id = st.store_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 group by 1, ad.address_id, 3
having count(distinct re.rental_id) = (select max(tmpval) from (
          select ad.district as "Район адреса",
                 ad.address as "Адрес",
                 st.store_id as "Идентификатор склада",
                 count(distinct re.rental_id) as tmpval
            from ADDRESS ad
            left join STORE st on st.address_id = ad.address_id
            left join INVENTORY iv on iv.store_id = st.store_id
            left join RENTAL re on re.inventory_id = iv.inventory_id
           group by 1, ad.address_id, 3
             ) tmpsel)
 order by 1, 2, 3

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент",
       re.rental_date as "Дата проката"
  from CUSTOMER c
  join RENTAL re on re.customer_id = c.customer_id
 where re.rental_date = (select max(re.rental_date)
       from CUSTOMER c
       join RENTAL re on re.customer_id = c.customer_id)
 order by 1

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент",
       re.rental_date as "Дата проката"
  from RENTAL re
  join CUSTOMER c on re.customer_id = c.customer_id
 where re.rental_date = (select max(re.rental_date)
       from RENTAL re
       join CUSTOMER c on re.customer_id = c.customer_id)
 order by 1

select distinct concat(c.first_name, ' ', c.last_name) as "Клиент",
       re.rental_date as "Дата проката"
  from CUSTOMER c
  join RENTAL re on re.customer_id = c.customer_id
 where re.rental_date = (select min(re.rental_date)
       from CUSTOMER c
       join RENTAL re on re.customer_id = c.customer_id)
 order by 1

select f.title as "Фильм",
       count(distinct re.rental_id) as "Количество прокатов"
  from FILM f
  left join INVENTORY iv on iv.film_id = f.film_id
  left join RENTAL re on re.inventory_id = iv.inventory_id
 group by f.film_id
having count(distinct re.rental_id) = (select min(tmpval) from (
          select f.title as "Фильм",
                 count(distinct re.rental_id) as tmpval
            from FILM f
            left join INVENTORY iv on iv.film_id = f.film_id
            left join RENTAL re on re.inventory_id = iv.inventory_id
           group by f.film_id
             ) tmpsel)
 order by 1