Wqrld · March 19, 2023 11:18
diff --git a/bestdays.sql b/bestdays.sql
 select SUM(amount) sum,DATE_FORMAT(STR_TO_DATE(date, '%d-%m-%Y %H:%i'), '%d-%m-%Y') as d
 from Payments 
 WHERE (state = 'approved' or state = 'paid') and client != 1
 group by d
 order by sum DESC;
	select SUM(amount) sum,DATE_FORMAT(STR_TO_DATE(date, '%d-%m-%Y %H:%i'), '%d-%m-%Y') as d
	from Payments
	WHERE (state = 'approved' or state = 'paid') and client != 1
	group by d
	order by sum DESC;