Rodrigo Coiado Dias

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 ;