moshiurse/WeeklyTransaction.sql

Created January 6, 2020 10:59

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/moshiurse/78fd4ccea448099b2aba4141b1f17fc3.js"></script>
Save moshiurse/78fd4ccea448099b2aba4141b1f17fc3 to your computer and use it in GitHub Desktop.

Download ZIP

Get top Bills from by week days

Raw

WeeklyTransaction.sql

	SELECT DAYNAME(inv_date+1), SUM(`total_cost`), COUNT(*) FROM `sales_invoice`
	GROUP BY DAYNAME(inv_date)
	ORDER BY SUM(`total_cost`) DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment