Skip to content

Instantly share code, notes, and snippets.

@zettamax

zettamax/free_trial_count.sql

Created February 17, 2015 08:49
Show Gist options
  • Save zettamax/34230ddedab548c07549 to your computer and use it in GitHub Desktop.
Save zettamax/34230ddedab548c07549 to your computer and use it in GitHub Desktop.
Download ZIP
Free trial pays group by date
Raw
free_trial_count.sql
select date(date) date_pay, count(*) cs from payments pm where pm.product_id in (select product_id from products pr where status = 'on' and params_provider like '%free_trial%') and log_id != 0 group by date_pay;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment