Q&A for active researchers, academics and students of physics
SELECT count(*) -- I want the year --distinct YEAR(CreationDate) as years -- and the total of new users for each year FROM USERS WHERE YEAR(CreationDate) in (SELECT distinct YEAR(CreationDate) from USERS)