9+ COVID 19
练习题链接 https://sqlzoo.net/wiki/Window_LAG
1.Introducing the covid table
SELECT name
,DAY(whn)
,confirmed
,deaths
,recovered
FROM covid
WHERE name = 'Spain'
AND MONTH(whn) = 3
ORDER BY whn
2.Introducing the LAG function
SELECT name
,DAY(whn)
,confirmed
,LAG(confirmed, 1) OVER (PARTITION BY name ORDER BY whn) AS dbf
FROM covid
WHERE name = 'Italy'
AND MONTH(whn) = 3
ORDER BY whn
关于LAG()函数是如何工作的,网站给出了图示