Baselight
SELECT 
  year, 
  education, 
  AVG(unemployment_rate) AS avg_unemployment_rate
FROM 
  @owid.unemployment.owid_unemployment 
WHERE 
  country = 'Spain' 
  AND year BETWEEN 1993 AND 2022
GROUP BY 
  year, 
  education
ORDER BY 
  year, 
  education;
yeareducationavg_unemployment_rate
1998Education Aggregate levels: Advanced17.47142825807844
1998Education Aggregate levels: Basic21.301428862980433
1998Education Aggregate levels: Intermediate19.230714525495255
1998Education Aggregate levels: Total20.10642889567784
1999Education Aggregate levels: Advanced14.402856997081212
1999Education Aggregate levels: Basic17.42785712650844
1999Education Aggregate levels: Intermediate17.302857535226003
1999Education Aggregate levels: Total16.78785698754447
2000Education Aggregate levels: Advanced12.463571548461914
2000Education Aggregate levels: Basic16.260714190346853
2000Education Aggregate levels: Intermediate14.270714010511126
2000Education Aggregate levels: Total15.012857164655413
2001Education Aggregate levels: Advanced9.231428674289159
2001Education Aggregate levels: Basic12.472142696380615
2001Education Aggregate levels: Intermediate10.990714413779122
2001Education Aggregate levels: Less than basic21.468999671936036
2001Education Aggregate levels: Total11.455714191709246
2002Education Aggregate levels: Advanced9.937142627579826
2002Education Aggregate levels: Basic13.457857404436384
2002Education Aggregate levels: Intermediate11.942142690931048
2002Education Aggregate levels: Total12.273571423121862
2003Education Aggregate levels: Advanced9.378571442195348
2003Education Aggregate levels: Basic13.882143020629883
2003Education Aggregate levels: Intermediate12.253571510314941
2003Education Aggregate levels: Less than basic24.578182220458984
2003Education Aggregate levels: Total11.184375166893005
2004Education Aggregate levels: Advanced10.082142795835223
2004Education Aggregate levels: Basic13.980714253016881
2004Education Aggregate levels: Intermediate11.7785712991442
2004Education Aggregate levels: Less than basic26.07400016784668
2004Education Aggregate levels: Total11.165624842047691
2005Education Aggregate levels: Advanced8.13714303289141
2005Education Aggregate levels: Basic11.01812493801117
2005Education Aggregate levels: Intermediate9.67714296068464
2005Education Aggregate levels: Less than basic27.455714634486608
2005Education Aggregate levels: Total9.4806247651577
2006Education Aggregate levels: Advanced7.280714290482657
2006Education Aggregate levels: Basic10.252500161528587
2006Education Aggregate levels: Intermediate8.860714333398002
2006Education Aggregate levels: Less than basic18.89363670349121
2006Education Aggregate levels: Total8.689999848604202
2007Education Aggregate levels: Advanced6.487142818314688
2007Education Aggregate levels: Basic10.303749784827232
2007Education Aggregate levels: Intermediate9.05571436882019
2007Education Aggregate levels: Less than basic25.528181596235797
2007Education Aggregate levels: Total8.598124876618385
2008Education Aggregate levels: Advanced7.655000039509365
2008Education Aggregate levels: Basic15.171249896287918
2008Education Aggregate levels: Intermediate11.307857138769966
2008Education Aggregate levels: Less than basic33.68142877306257
2008Education Aggregate levels: Total11.72500017285347
2009Education Aggregate levels: Advanced12.197142975670952
2009Education Aggregate levels: Basic23.88124978542328
2009Education Aggregate levels: Intermediate18.23857150759016
2009Education Aggregate levels: Less than basic45.32857077462332
2009Education Aggregate levels: Total18.42062497138977
2010Education Aggregate levels: Advanced13.857857261385236
2010Education Aggregate levels: Basic26.668125182390213
2010Education Aggregate levels: Intermediate20.605714184897288
2010Education Aggregate levels: Less than basic45.421428952898296
2010Education Aggregate levels: Total20.504999965429306
2011Education Aggregate levels: Advanced16.137142487934657
2011Education Aggregate levels: Basic28.267499804496765
2011Education Aggregate levels: Intermediate23.69214309964861
2011Education Aggregate levels: Less than basic52.53999918157404
2011Education Aggregate levels: Total22.314999639987946
2012Education Aggregate levels: Advanced16.885000348091125
2012Education Aggregate levels: Basic33.20687448978424
2012Education Aggregate levels: Intermediate27.492857660566056
2012Education Aggregate levels: Less than basic54.71545479514382
2012Education Aggregate levels: Total26.09000051021576
2013Education Aggregate levels: Advanced18.446874767541885
2013Education Aggregate levels: Basic35.47312533855438
2013Education Aggregate levels: Intermediate29.307142530168807
2013Education Aggregate levels: Less than basic54.788182345303625
2013Education Aggregate levels: Total27.860625207424164
2014Education Aggregate levels: Advanced17.226249754428864
2014Education Aggregate levels: Basic33.51624983549118
2014Education Aggregate levels: Intermediate27.887856483459473
2014Education Aggregate levels: Less than basic50.06928498404367
2014Education Aggregate levels: Total26.382499754428864
2015Education Aggregate levels: Advanced15.353124737739563
2015Education Aggregate levels: Basic30.912500262260437
2015Education Aggregate levels: Intermediate25.051428249904088
2015Education Aggregate levels: Less than basic40.37374973297119
2015Education Aggregate levels: Total23.880000174045563
2016Education Aggregate levels: Advanced15.364285605294365
2016Education Aggregate levels: Basic28.618749916553497
2016Education Aggregate levels: Intermediate20.539374709129333
2016Education Aggregate levels: Less than basic39.108749866485596
2016Education Aggregate levels: Total21.665624976158142
2017Education Aggregate levels: Advanced11.590624809265137
2017Education Aggregate levels: Basic25.52625009417534
2017Education Aggregate levels: Intermediate18.227500200271606
2017Education Aggregate levels: Less than basic36.46875011920929
2017Education Aggregate levels: Total18.99312514066696
2018Education Aggregate levels: Advanced10.270624965429306
2018Education Aggregate levels: Basic22.891874730587006
2018Education Aggregate levels: Intermediate17.00499999523163
2018Education Aggregate levels: Less than basic40.63428619929722
2018Education Aggregate levels: Total16.988750100135803
2019Education Aggregate levels: Advanced10.395624786615372
2019Education Aggregate levels: Basic21.40937489271164
2019Education Aggregate levels: Intermediate15.878124952316284
2019Education Aggregate levels: Less than basic35.16499996185303
2019Education Aggregate levels: Total15.981874823570251
2020Education Aggregate levels: Advanced12.301874995231628
2020Education Aggregate levels: Basic23.827500343322754
2020Education Aggregate levels: Intermediate18.076249957084656
2020Education Aggregate levels: Less than basic36.09499972207205
2020Education Aggregate levels: Total17.883749544620514
2021Education Aggregate levels: Advanced10.9706249833107
2021Education Aggregate levels: Basic23.416249811649323
2021Education Aggregate levels: Intermediate17.537499725818634
2021Education Aggregate levels: Less than basic28.505714416503906
2021Education Aggregate levels: Total16.88562500476837
2022Education Aggregate levels: Advanced8.997500091791153
2022Education Aggregate levels: Basic21.31062525510788
2022Education Aggregate levels: Intermediate15.209375083446503
2022Education Aggregate levels: Less than basic27.87428569793701
2022Education Aggregate levels: Total14.725625157356262

Share link

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