Skip to content

Latest commit

History

7 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

Registered users in the current year

SELECT
TO_CHAR(created_at, 'Month') AS month,
COUNT(*) AS registered_users
FROM users
WHERE EXTRACT(YEAR FROM created_at) = EXTRACT(YEAR FROMCURRENT_TIMESTAMP)
GROUP BY TO_CHAR(created_at, 'Month')
ORDER BY TO_CHAR(created_at, 'Month') ASC;

About

Example of remote storage

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Used by

Contributors

Languages