sum(case when max(date) then 1 else 0 end)

[Hal Campbell]

I am new to MySQL so I thank you in advance for your help.

I have a subscription table that contains subscriptions for a user. Each user could have multiple rows indicating their subscription history. Each rows in the subscription table contain "Date Created"=created_date and "Expiration Date" = exp_date.

I need to calculate the total number of rows where created_date is within a date range and number of rows that contains exp_Date within a date range.

For exp_date I need to check the oldest or MAX exp_date.

Here is what I've tried but using Max within the case doesn't work.



Select
SUM(Case when created_date between 'yyyy-mm-dd' and 'yyyy-mm-dd' then 1 else 0 end) as Created_Count
sum(case when max(Exp_Date between 'yyyy-mm-dd' and 'yyyy-mm-dd' then 1 else 0 end) as Exp_Count