MostafaNorzade/sort_sub_by_count

Created December 21, 2020 11:21

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/MostafaNorzade/8e73d5912964e538546660b445ab2b48.js"></script>
Save MostafaNorzade/8e73d5912964e538546660b445ab2b48 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

sort_sub_by_count

SELECT COUNT(*) as count, created_at FROM `subscriptions` WHERE status != 0 GROUP BY DATE(`created_at`) ORDER BY count DESC

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