$ ./guess_the_languageProgramming Languages
Programming Languages · hard · #599

Which programming language is this?

SELECT day, revenue,
  revenue - LAG(revenue) OVER (ORDER BY day) AS change,
  SUM(revenue) OVER (
    ORDER BY day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
  ) AS week_total
FROM daily_sales;

Answer: SQL

Window functions LAG(...) OVER (...) and a ROWS BETWEEN 6 PRECEDING AND CURRENT ROW frame are SQL.
Play Programming Languages ▸