select
a.productVersion as Version,
count(a.licenseId) as Activation_Count,
DATE_FORMAT(a.lastActivatedOn,
GET_FORMAT(DATE,'USA')) as Date,
TO_DAYS(a.lastActivatedOn) as Days

from
activations as a,
((select licenseId from licenses
where TRUE
and (InstallType='trial' or InstallType='trialExtended')
and creator!='Website 10 Free'
and validUntil >= "2011-12-1"
-- and validFrom <= "2012-1-1"
) as l)

where TRUE
-- and getProductMajorVersion(a.productVersion) >= 7
and (a.productVersion like "7%" or  a.productVersion like "8%")
and a.licenseId = l.licenseId
and a.lastActivatedOn >= "2011-12-1"

group by Days, Version
order by Days desc, Version desc;

select
a.productVersion as Version,
count(a.lid) as Activation_Count,
DATE_FORMAT(a.lastActivatedOn, GET_FORMAT(DATE,'USA')) as Date,
TO_DAYS(a.lastActivatedOn) as Days

from
activations as a,
licenses as l


where TRUE
-- getProductMajorVersion(a.productVersion) >= 7
and (a.productVersion like "7%" or  a.productVersion like "8%")
and (l.InstallType='trial' or l.InstallType='trialExtended')
and l.creator!='Website 10 Free'
and l.validUntil >= "2011-12-1"
and a.lid = l.lidand a.lastActivatedOn >= "2011-12-1"


group by Days, Version
order by Days desc, Version desc;