why-so-many-software.sh

sqlite3 :memory: \
 '.mode csv' \
 '.import "|curl -s https://gist.githubusercontent.com/zhonglism/f146a9423e2c975de8d03c26451f841e/raw/f79e190df4225caed58bf360d8e20a9fa872b4ac/vgsales.csv" hlp' \
 "
  WITH vgsales AS (
    SELECT name, cast(global_sales as number) * 1000000 AS sales, cast(year as number) AS year FROM hlp WHERE year != 'N/A'
  ),
  per_year AS (
    SELECT year, name, sales, dense_rank() OVER (PARTITION BY year ORDER BY sales DESC) AS rnk FROM vgsales
  )
  SELECT year, rnk, name, sales FROM per_year WHERE rnk <= 3 AND year >= 2010 ORDER BY year ASC"