SQLZOO英文版答案记录/Window LAG

1

SELECT name, DAY(whn) as March, confirmed, deaths, recovered
FROM covid
WHERE name = 'Spain'
AND MONTH(whn) = 3 AND YEAR(whn) = 2020
ORDER BY whn

2、LAG（，n）函数是显示前n行的数据

SELECT name, DAY(whn), confirmed,
       LAG(confirmed,1) OVER (PARTITION BY name ORDER BY whn)
FROM covid
WHERE name = 'Italy'
AND MONTH(whn) = 3 AND YEAR(whn) = 2020
ORDER BY whn

3、新增=当天累计-前一天累计

SELECT name, DAY(whn), 
       confirmed-LAG(confirmed, 1) OVER (PARTITION BY name ORDER BY whn)
FROM covid
WHERE name = 'Italy'
AND MONTH(whn) = 3 AND YEAR(whn) = 2020
ORDER BY whn

4、总是报错'DATE_FORMAT' is not a recognized built-in function name.的情况下