Untitled

 avatar
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;