SQL Formatter
Format
SQL
N1QL
DB2
SELECT count(*) count, winner, counter * (60 * 5) as counter FROM (SELECT winner, round(length / (60 * 5)) as counter FROM players WHERE build = $1 AND (hero = $2 OR region = $3)) GROUP BY winner, counter; INSERT INTO players(build, hero, region, winner, length) VALUES ($1, $2, $3, $4, $5); INSERT INTO players SELECT players_copy ORDER BY length; UPDATE players SET count = 0 WHERE build = $1 AND (hero = $2 OR region = $3) LIMIT 1;