# Review canceled subscribers
```
SELECT * FROM subscriptions as s inner join users as u on u.id = s.user_id  WHERE `end_date` <= '2024-07-14 17:35:54' and roles > 0 ORDER BY `user_id` ASC 
```


# Number of new users per month for the last two yeasr
```
SELECT
    DATE_FORMAT(created_at, '%Y-%m') AS month,
    COUNT(*) AS new_users
FROM
    users
WHERE
    created_at >= DATE_SUB(CURDATE(), INTERVAL 2 YEAR)
GROUP BY
    month
ORDER BY
    month;
```


# Number of new pols per month for the last two yeasr
```
SELECT
    DATE_FORMAT(created_at, '%Y-%m') AS month,
    COUNT(*) AS new_polls
FROM
    polls
WHERE
    created_at >= DATE_SUB(CURDATE(), INTERVAL 2 YEAR)
GROUP BY
    month
ORDER BY
    month;
```



#number of total users per mont 

```
SELECT
    months.month,
    COUNT(users.id) AS total_users
FROM
    (SELECT 
         DATE_FORMAT(created_at, '%Y-%m') AS month
     FROM 
         users
     WHERE 
         created_at >= DATE_SUB(CURDATE(), INTERVAL 2 YEAR)
     GROUP BY 
         DATE_FORMAT(created_at, '%Y-%m')
     ) AS months
LEFT JOIN
    users ON DATE_FORMAT(users.created_at, '%Y-%m') <= months.month
GROUP BY
    months.month
ORDER BY
    months.month;

```