Chess with SQL

 Chess in Pure SQL - DB Pro Blog

-- Kasparov vs Topalov, 1999
-- After the legendary 24. Rxd4!! rook sacrifice
INSERT INTO board (rank, file, piece) VALUES
(1, 6, '♖'), (1, 7, '♔'),
(2, 1, '♙'), (2, 6, '♙'), (2, 7, '♙'), (2, 8, '♙'),
(3, 2, '♙'), (3, 3, '♗'),
(4, 4, '♖'),  -- The sacrificed rook
(5, 3, '♙'),
(8, 2, '♜'), (8, 7, '♚'),
(7, 1, '♟'), (7, 6, '♟'), (7, 8, '♟'),
(6,