SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select row_number() over() order by date_format(rental_date,'%M-%Y') asc as date, sales from (select count(inventory_id) as sales, date_format(rental_date,'%M-%Y') as date from rental group by date_format(rental_date,'%M-%Y') order by date_format(rental_date,'%M-%Y') asc) t1
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear