Baselight
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
yearmin_anomaly_below_0max_anomaly_above_0
1940-0.49912357330322266null
1941-0.4748401641845703null
1942-0.7484760284423828null
1943-0.7765636444091797null
1944-0.4685544967651367null
1945-0.33533477783203125null
1946-0.6698112487792969null
1947-0.6639566421508789null
1948-0.57049560546875null
1949-0.6661224365234375null
1950-0.8166046142578125null
1951-0.4882011413574219null
1952-0.6869316101074219null
1953-0.5297565460205078null
1954-0.8022775650024414null
1955-0.5998764038085938null
1956-0.8837051391601562null
1957-0.5275840759277344null
1958-0.5775661468505859null
1959-0.593724250793457null
1960-0.5319795608520508null
1961-0.5490293502807617null
1962-0.6011562347412109null
1963-0.3528308868408203null
1964-0.6946620941162109null
1965-0.6724491119384766null
1966-0.5796337127685547null
1967-0.5711536407470703null
1968-0.6529150009155273null
1969-0.6583824157714844null
1970-0.6839275360107422null
1971-0.7044305801391602null
1972-0.45670413970947266null
1973-0.6240673065185547null
1974-0.6212005615234375null
1975-0.8382177352905273null
1976-0.7534780502319336null
1977-0.4668397903442383null
1978-0.7221889495849609null
1979-0.40953922271728516null
1980-0.2845010757446289null
1981-0.23632144927978516null
1982-0.45393943786621094null
1983-0.2498311996459961null
1984-0.4386262893676758null
1985-0.39429283142089844null
1986-0.4373435974121094null
1987-0.2709331512451172null
1988-0.16663169860839844null
1989-0.3217134475708008null
1990-0.16622066497802734null
1991-0.1398305892944336null
1992-0.48837852478027344null
1993-0.3846759796142578null
1994-0.3845653533935547null
1995-0.107147216796875null
1996-0.11178970336914062null
1997-0.1342611312866211null
1998null0.14119529724121094
1999-0.237823486328125null
2000-0.17530059814453125null
2001-0.05120849609375null
2002-0.0468597412109375null
2003null0.04565238952636719
2004-0.16184329986572266null
2005null0.029336929321289062
2006null0.07070732116699219
2007-0.019002914428710938null
2008-0.07928466796875null
2009null0.044933319091796875
2010null0.04585075378417969
2011null0.11047744750976562
2012null0.07608985900878906
2013null0.054332733154296875
2014null0.1355457305908203
2015null0.2418041229248047
2016null0.4007701873779297
2017null0.2954750061035156
2018null0.20798873901367188
2019null0.35555267333984375
2020null0.26625633239746094
2021null0.3106212615966797
2022null0.2952136993408203
2023null0.7090625762939453
2024null0.7105751037597656

Share link

Anyone who has the link will be able to view this.