Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
191 B
0
Indexable
Never
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;