Untitled
unknown
plain_text
a year ago
191 B
1
Indexable
select monthname(order_date) as Bulan, sum(after_discount) as 'Total Nilai Transaksi' from order_detail where extract(year from order_date) = 2021 and is_valid = 1 group by 1 order by 2 desc;
select monthname(order_date) as Bulan, sum(after_discount) as 'Total Nilai Transaksi' from order_detail where extract(year from order_date) = 2021 and is_valid = 1 group by 1 order by 2 desc;