1SELECT "year", SUM("count")
2FROM @kaggle.robikscube_us_baby_name_popularity.names
3WHERE
4 "name" = 'Rose'
5GROUP by "year"
6ORDER by "year" DESC| year | sum(count) |
|---|---|
| 2021 | 2377 |
| 2020 | 2377 |
| 2019 | 2522 |
| 2018 | 2451 |
| 2017 | 2080 |
| 2016 | 2039 |
| 2015 | 1950 |
| 2014 | 1697 |
| 2013 | 1427 |
| 2012 | 1251 |
| 2011 | 1098 |
| 2010 | 962 |
| 2009 | 939 |
| 2008 | 974 |
| 2007 | 942 |
| 2006 | 961 |
| 2005 | 967 |
| 2004 | 894 |
| 2003 | 853 |
| 2002 | 922 |
| 2001 | 1029 |
| 2000 | 1080 |
| 1999 | 1132 |
| 1998 | 1019 |
| 1997 | 666 |
| 1996 | 703 |
| 1995 | 787 |
| 1994 | 791 |
| 1993 | 749 |
| 1992 | 864 |
| 1991 | 894 |
| 1990 | 901 |
| 1989 | 905 |
| 1988 | 877 |
| 1987 | 836 |
| 1986 | 832 |
| 1985 | 978 |
| 1984 | 1065 |
| 1983 | 1066 |
| 1982 | 1107 |
| 1981 | 1101 |
| 1980 | 1142 |
| 1979 | 928 |
| 1978 | 920 |
| 1977 | 965 |
| 1976 | 972 |
| 1975 | 947 |
| 1974 | 1064 |
| 1973 | 1102 |
| 1972 | 1319 |
| 1971 | 1441 |
| 1970 | 1794 |
| 1969 | 1880 |
| 1968 | 1961 |
| 1967 | 2260 |
| 1966 | 2546 |
| 1965 | 2876 |
| 1964 | 3501 |
| 1963 | 3718 |
| 1962 | 4027 |
| 1961 | 4331 |
| 1960 | 4906 |
| 1959 | 5466 |
| 1958 | 6073 |
| 1957 | 6920 |
| 1956 | 7359 |
| 1955 | 7870 |
| 1954 | 8022 |
| 1953 | 7027 |
| 1952 | 6569 |
| 1951 | 6202 |
| 1950 | 5391 |
| 1949 | 5395 |
| 1948 | 5580 |
| 1947 | 5673 |
| 1946 | 5192 |
| 1945 | 4574 |
| 1944 | 4722 |
| 1943 | 5237 |
| 1942 | 5275 |
| 1941 | 4989 |
| 1940 | 5230 |
| 1939 | 5080 |
| 1938 | 5329 |
| 1937 | 5488 |
| 1936 | 5732 |
| 1935 | 5264 |
| 1934 | 5628 |
| 1933 | 5813 |
| 1932 | 6518 |
| 1931 | 6913 |
| 1930 | 7751 |
| 1929 | 7837 |
| 1928 | 8204 |
| 1927 | 8544 |
| 1926 | 8555 |
| 1925 | 8315 |
| 1924 | 8506 |
| 1923 | 8471 |
| 1922 | 8828 |
| 1921 | 9372 |
| 1920 | 9035 |
| 1919 | 9229 |
| 1918 | 9603 |
| 1917 | 9821 |
| 1916 | 9643 |
| 1915 | 9398 |
| 1914 | 7612 |
| 1913 | 6188 |
| 1912 | 5445 |
| 1911 | 4173 |
| 1910 | 3853 |
| 1909 | 3397 |
| 1908 | 3405 |
| 1907 | 3140 |
| 1906 | 2920 |
| 1905 | 2741 |
| 1904 | 2641 |
| 1903 | 2493 |
| 1902 | 2451 |
| 1901 | 2220 |
| 1900 | 2855 |
| 1899 | 2210 |
| 1898 | 2444 |
| 1897 | 2328 |
| 1896 | 2351 |
| 1895 | 2270 |
| 1894 | 2132 |
| 1893 | 2020 |
| 1892 | 2039 |
| 1891 | 1701 |
| 1890 | 1733 |
| 1889 | 1561 |
| 1888 | 1599 |
| 1887 | 1248 |
| 1886 | 1267 |
| 1885 | 1173 |
| 1884 | 1065 |
| 1883 | 882 |
| 1882 | 886 |
| 1881 | 734 |
| 1880 | 707 |