leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE |

0626.sql (154B)


1 SELECT F.id, IFNULL(S.student, F.student) AS student 2 FROM Seat F 3 LEFT JOIN Seat S 4 ON F.id % 2 = 1 AND F.id + 1 = S.id 5 OR F.id % 2 = 0 AND F.id - 1 = S.id