Denunciar Esclarecimento de dúvida - Operadores Count sum e avg em SQL Server Postado Agosto 4, 2021 Olá bom dia, Como faço para encontrar qual o cliente que mais alugou por valor monetário? select cus.first_name, cus.last_name, addr.address, cit.city, cou.country, ren.staff_id, pay.amount from customer cus inner join address addr on cus.address_id = addr.address_id inner join city cit on addr.city_id = cit.city_id inner join country cou on cit.country_id = cou.country_id INNER JOIN rental ren on cus.customer_id = ren.customer_id inner join payment pay on ren.rental_id = pay.rental_id where amount like >= '10' group by cus.first_name, cus.last_name, addr.address, cit.city, cou.country, ren.staff_id, pay.amount order by amount asc ;
Esclarecimento de dúvida - Operadores Count sum e avg
em SQL Server
Postado
Olá bom dia,
Como faço para encontrar qual o cliente que mais alugou por valor monetário?
select cus.first_name, cus.last_name,
addr.address, cit.city, cou.country, ren.staff_id, pay.amount
from customer cus
inner join address addr
on cus.address_id = addr.address_id
inner join city cit
on addr.city_id = cit.city_id
inner join country cou
on cit.country_id = cou.country_id
INNER JOIN rental ren
on cus.customer_id = ren.customer_id
inner join payment pay
on ren.rental_id = pay.rental_id
where amount like >= '10'
group by cus.first_name, cus.last_name,
addr.address, cit.city, cou.country, ren.staff_id, pay.amount
order by amount asc ;