AblePro Developer Tools

SQL Studio

Format, inspect, build, and review SQL without sending queries or database information to a server.

Local browser workspace

6Lines

29Words

2Tables found

0Warnings

SQL inputNothing is executed against a database.

SELECT c.id,
  c.name,
  COUNT(o.id) AS order_count
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
WHERE c.active = 1
GROUP BY c.id,
  c.name
ORDER BY order_count DESC;

Important: SQL Studio performs text analysis only. It does not connect to, query, or modify any database.