プログラマーとプログラミングに熱心な人々のための質問と回答
SELECT distinct YEAR(CreationDate) -- 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)