SHOW:
|
|
- or go back to the newest paste.
1 | select 01 mo_id, "March 2012" month, (select count(*) created from tickets where created_at > '2012-03-01 00:00:00' and created_at < '2012-04-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-03-01 00:00:00' and closed_at < '2012-04-01 00:00:00') closed UNION | |
2 | select 02 mo_id, "April 2012" month, (select count(*) created from tickets where created_at > '2012-04-01 00:00:00' and created_at < '2012-05-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-04-01 00:00:00' and closed_at < '2012-05-01 00:00:00') closed UNION | |
3 | select 03 mo_id, "May 2012" month, (select count(*) created from tickets where created_at > '2012-05-01 00:00:00' and created_at < '2012-06-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-05-01 00:00:00' and closed_at < '2012-06-01 00:00:00') closed UNION | |
4 | select 04 mo_id, "June 2012" month, (select count(*) created from tickets where created_at > '2012-06-01 00:00:00' and created_at < '2012-07-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-06-01 00:00:00' and closed_at < '2012-07-01 00:00:00') closed UNION | |
5 | select 05 mo_id, "July 2012" month, (select count(*) created from tickets where created_at > '2012-07-01 00:00:00' and created_at < '2012-08-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-07-01 00:00:00' and closed_at < '2012-08-01 00:00:00') closed UNION | |
6 | select 06 mo_id, "August 2012" month, (select count(*) created from tickets where created_at > '2012-08-01 00:00:00' and created_at < '2012-09-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-08-01 00:00:00' and closed_at < '2012-09-01 00:00:00') closed UNION | |
7 | select 07 mo_id, "September 2012" month, (select count(*) created from tickets where created_at > '2012-09-01 00:00:00' and created_at < '2012-10-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-09-01 00:00:00' and closed_at < '2012-10-01 00:00:00') closed UNION | |
8 | select 08 mo_id, "October 2012" month, (select count(*) created from tickets where created_at > '2012-10-01 00:00:00' and created_at < '2012-11-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-10-01 00:00:00' and closed_at < '2012-11-01 00:00:00') closed UNION | |
9 | select 09 mo_id, "November 2012" month, (select count(*) created from tickets where created_at > '2012-11-01 00:00:00' and created_at < '2012-12-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-11-01 00:00:00' and closed_at < '2012-12-01 00:00:00') closed UNION | |
10 | select 10 mo_id, "December 2012" month, (select count(*) created from tickets where created_at > '2012-12-01 00:00:00' and created_at < '2013-01-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-12-01 00:00:00' and closed_at < '2013-01-01 00:00:00') closed UNION | |
11 | select 11 mo_id, "January 2013" month, (select count(*) created from tickets where created_at > '2013-01-01 00:00:00' and created_at < '2013-02-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-01-01 00:00:00' and closed_at < '2013-02-01 00:00:00') closed UNION | |
12 | select 12 mo_id, "February 2013" month, (select count(*) created from tickets where created_at > '2013-02-01 00:00:00' and created_at < '2013-03-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-02-01 00:00:00' and closed_at < '2013-03-01 00:00:00') closed UNION | |
13 | select 13 mo_id, "March 2013" month, (select count(*) created from tickets where created_at > '2013-03-01 00:00:00' and created_at < '2013-04-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-03-01 00:00:00' and closed_at < '2013-04-01 00:00:00') closed UNION | |
14 | select 14 mo_id, "April 2013" month, (select count(*) created from tickets where created_at > '2013-04-01 00:00:00' and created_at < '2013-05-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-04-01 00:00:00' and closed_at < '2013-05-01 00:00:00') closed UNION | |
15 | select 15 mo_id, "May 2013" month, (select count(*) created from tickets where created_at > '2013-05-01 00:00:00' and created_at < '2013-06-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-05-01 00:00:00' and closed_at < '2013-06-01 00:00:00') closed UNION | |
16 | - | select 16 mo_id, "June 2013" month, (select count(*) created from tickets where created_at > '2013-06-01 00:00:00' and created_at < '2013-07-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-06-01 00:00:00' and closed_at < '2013-07-01 00:00:00') closed UNION |
16 | + | select 16 mo_id, "June 2013" month, (select count(*) created from tickets where created_at > '2013-06-01 00:00:00' and created_at < '2013-07-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-06-01 00:00:00' and closed_at < '2013-07-01 00:00:00') |