Just shipped 1v1 PvP on a SQL game I've been building.
Both players see the same prompt and schema, race to write a query that returns the correct rows. Result sets are compared, so joins vs subqueries vs CTEs all work - speed is what matters.
Video is a real match. I'll be in the comments.