XY______的博客

链接：https://sqlzoo.net/wiki/Window_LAG1.SELECT name, DAY(whn), confirmed, deaths, recovered FROM covidWHERE name = 'Spain' AND MONTH(whn) = 3ORDER BY whnSELECT name, DAY(whn), confirmed, LAG(confirmed, 1, null) OVER( PARTITION BY name ORDER BY

链接：https://sqlzoo.net/wiki/Window_functionsSELECT lastName, party, votesFROM geWHERE constituency = 'S14000024' AND yr = 2017ORDER BY votes DESCSELECT party, votes, RANK() OVER (ORDER BY votes DESC) as posn FROM ge WHERE constituen

链接：https://sqlzoo.net/wiki/Self_joinSELECT COUNT(id)FROM stopsSELECT idFROM stopsWHERE name='Craiglockhart'SELECT stops.id, stops.name FROM stops JOIN route ON stops.id=route.stopWHERE route.num='4' AND route.company='LRT'SELECT

链接：https://sqlzoo.net/wiki/Using_NullSELECT nameFROM teacherWHERE dept IS NULLSELECT teacher.name, dept.nameFROM teacher INNER JOIN dept ON (teacher.dept=dept.id)SELECT teacher.name, dept.name FROMteacher LEFT JOIN dept ON

链接：https://sqlzoo.net/wiki/More_JOIN_operations1.SELECT id, titleFROM movieWHERE yr=1962SELECT yrFROM movieWHERE title='Citizen Kane'SELECT id,title,yrFROM movieWHERE title LIKE 'Star Trek%'SELECT idFROM actorWHERE name='Glenn

链接：https://sqlzoo.net/wiki/The_JOIN_operation1.SELECT matchid,playerFROM goal WHERE teamid='GER'SELECT id,stadium,team1,team2FROM gameWHERE id='1012'SELECT goal.player,goal.teamid,game.stadium,game.mdateFROM game JOIN goal ON (game.id