Average number of legendary creatures over time

legovertime

From EDHREC data, April 21st, 2018

SELECT to_char, AVG(numleg) FROM (SELECT decks.url, numleg, to_char(savedate, 'YYYY-MM') FROM (SELECT aa.url, COUNT(*) as numleg FROM (SELECT * FROM cards JOIN cardref ON cards.card = cardref.name WHERE cardref.type LIKE 'Legendary Creature%') aa GROUP BY url) bb JOIN decks ON bb.url=decks.url) cc GROUP BY to_char ORDER BY to_char;

 Month   | Average number of Legendary Creatures
 2014-09 | 3.5555555555555556
 2014-10 | 3.7694524495677233
 2014-11 | 3.5817575083426029
 2014-12 | 3.7218193803559657
 2015-01 | 3.6833881578947368
 2015-02 | 3.5854879065888240
 2015-03 | 3.8462206776715899
 2015-04 | 3.9546769527483124
 2015-05 | 3.7228207639569050
 2015-06 | 3.8729674796747967
 2015-07 | 3.9883268482490272
 2015-08 | 3.9204346302138100
 2015-09 | 3.9478162223482700
 2015-10 | 3.9717717717717718
 2015-11 | 3.9804687500000000
 2015-12 | 3.9631966351209253
 2016-01 | 3.8789473684210526
 2016-02 | 3.7401490947816826
 2016-03 | 4.0347533632286996
 2016-04 | 4.1398631308810950
 2016-05 | 3.9750692520775623
 2016-06 | 4.0970785149117468
 2016-07 | 4.0475143726750085
 2016-08 | 4.0014224751066856
 2016-09 | 4.1286882332029861
 2016-10 | 4.1065525383707202
 2016-11 | 4.4874963224477788
 2016-12 | 4.3861889412348128
 2017-01 | 4.2183139875718138
 2017-02 | 4.1690776649225403
 2017-03 | 4.2362212629254091
 2017-04 | 4.1828978622327791
 2017-05 | 4.2410263055591551
 2017-06 | 4.2100720996285777
 2017-07 | 4.1718845293758894
 2017-08 | 4.1760091684706482
 2017-09 | 4.4213972522654195
 2017-10 | 4.3365292425695110
 2017-11 | 4.3572914259302057
 2017-12 | 4.2470862470862471
 2018-01 | 4.2477064220183486
 2018-02 | 4.1927891837756635
 2018-03 | 4.3130311614730878
 2018-04 | 4.2057010785824345