SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select last_name,first_name ,count(rental_id) cnt from rental t1 inner join customer t2 on t1.customer_id=t2.customer_id group by last_name,first_name order by rank() over ( order by count(rental_id)) desc,1; SHOW STATUS LIKE 'Last_query_cost';

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear