select year(time) as year, min(anomaly_below_0) as min_anomaly_below_0, max(anomaly_above_0) as max_anomaly_above_0
from @owid.surface_temperature.owid_surface_temperature_1
where country = 'World' and month(time) = 8
group by 1
order by 1| year | min_anomaly_below_0 | max_anomaly_above_0 |
|---|---|---|
| 1940 | -0.49912357330322266 | null |
| 1941 | -0.4748401641845703 | null |
| 1942 | -0.7484760284423828 | null |
| 1943 | -0.7765636444091797 | null |
| 1944 | -0.4685544967651367 | null |
| 1945 | -0.33533477783203125 | null |
| 1946 | -0.6698112487792969 | null |
| 1947 | -0.6639566421508789 | null |
| 1948 | -0.57049560546875 | null |
| 1949 | -0.6661224365234375 | null |
| 1950 | -0.8166046142578125 | null |
| 1951 | -0.4882011413574219 | null |
| 1952 | -0.6869316101074219 | null |
| 1953 | -0.5297565460205078 | null |
| 1954 | -0.8022775650024414 | null |
| 1955 | -0.5998764038085938 | null |
| 1956 | -0.8837051391601562 | null |
| 1957 | -0.5275840759277344 | null |
| 1958 | -0.5775661468505859 | null |
| 1959 | -0.593724250793457 | null |
| 1960 | -0.5319795608520508 | null |
| 1961 | -0.5490293502807617 | null |
| 1962 | -0.6011562347412109 | null |
| 1963 | -0.3528308868408203 | null |
| 1964 | -0.6946620941162109 | null |
| 1965 | -0.6724491119384766 | null |
| 1966 | -0.5796337127685547 | null |
| 1967 | -0.5711536407470703 | null |
| 1968 | -0.6529150009155273 | null |
| 1969 | -0.6583824157714844 | null |
| 1970 | -0.6839275360107422 | null |
| 1971 | -0.7044305801391602 | null |
| 1972 | -0.45670413970947266 | null |
| 1973 | -0.6240673065185547 | null |
| 1974 | -0.6212005615234375 | null |
| 1975 | -0.8382177352905273 | null |
| 1976 | -0.7534780502319336 | null |
| 1977 | -0.4668397903442383 | null |
| 1978 | -0.7221889495849609 | null |
| 1979 | -0.40953922271728516 | null |
| 1980 | -0.2845010757446289 | null |
| 1981 | -0.23632144927978516 | null |
| 1982 | -0.45393943786621094 | null |
| 1983 | -0.2498311996459961 | null |
| 1984 | -0.4386262893676758 | null |
| 1985 | -0.39429283142089844 | null |
| 1986 | -0.4373435974121094 | null |
| 1987 | -0.2709331512451172 | null |
| 1988 | -0.16663169860839844 | null |
| 1989 | -0.3217134475708008 | null |
| 1990 | -0.16622066497802734 | null |
| 1991 | -0.1398305892944336 | null |
| 1992 | -0.48837852478027344 | null |
| 1993 | -0.3846759796142578 | null |
| 1994 | -0.3845653533935547 | null |
| 1995 | -0.107147216796875 | null |
| 1996 | -0.11178970336914062 | null |
| 1997 | -0.1342611312866211 | null |
| 1998 | null | 0.14119529724121094 |
| 1999 | -0.237823486328125 | null |
| 2000 | -0.17530059814453125 | null |
| 2001 | -0.05120849609375 | null |
| 2002 | -0.0468597412109375 | null |
| 2003 | null | 0.04565238952636719 |
| 2004 | -0.16184329986572266 | null |
| 2005 | null | 0.029336929321289062 |
| 2006 | null | 0.07070732116699219 |
| 2007 | -0.019002914428710938 | null |
| 2008 | -0.07928466796875 | null |
| 2009 | null | 0.044933319091796875 |
| 2010 | null | 0.04585075378417969 |
| 2011 | null | 0.11047744750976562 |
| 2012 | null | 0.07608985900878906 |
| 2013 | null | 0.054332733154296875 |
| 2014 | null | 0.1355457305908203 |
| 2015 | null | 0.2418041229248047 |
| 2016 | null | 0.4007701873779297 |
| 2017 | null | 0.2954750061035156 |
| 2018 | null | 0.20798873901367188 |
| 2019 | null | 0.35555267333984375 |
| 2020 | null | 0.26625633239746094 |
| 2021 | null | 0.3106212615966797 |
| 2022 | null | 0.2952136993408203 |
| 2023 | null | 0.7090625762939453 |
| 2024 | null | 0.7105751037597656 |