Welcome to XCODX Online Compiler
Quick Start:
Ctrl+Enter Run code
Ctrl+S Save / Download
Ctrl+L Clear output
Select a language and start coding.
SQLite is the most widely deployed database engine in existence — it ships inside every iPhone and Android device, every major browser, and countless embedded systems, all from a single C library small enough to measure in kilobytes. It's also the ideal vehicle for learning SQL: no server to configure, no credentials, no connection strings — just statements and results. This page executes your script against a real SQLite engine in the cloud: CREATE tables, INSERT rows, then query them with joins, aggregates, CTEs, and window functions, with result rows printed straight to the terminal. It's the fastest route from "I should practice SQL" to actually practicing SQL.
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
grade REAL
);
INSERT INTO students (name, grade) VALUES
('Ava', 91.5),
('Liam', 78.0),
('Noah', 85.25),
('Mia', 96.0);
-- Who is passing with distinction?
SELECT name, grade
FROM students
WHERE grade >= 85
ORDER BY grade DESC;
-- Class summary
SELECT COUNT(*) AS total_students,
ROUND(AVG(grade), 2) AS avg_grade,
MAX(grade) AS top_grade
FROM students;Drill the SQL round that appears in nearly every data-analyst, backend, and data-engineering interview — joins, GROUP BY with HAVING, subqueries, and the window functions (ROW_NUMBER, RANK, LAG) that separate strong candidates — by building a tiny dataset and querying it live. Database-course students can run homework schemas without installing anything, developers can prototype a table design before writing a migration, and anyone can paste an unfamiliar query from a code review to see exactly what it returns.
It's the genuine SQLite engine — your statements execute top to bottom against a real (temporary) database, and query results stream to the terminal as each SELECT runs. Constraints, foreign keys, and error messages behave exactly as documented at sqlite.org, because it is that exact software.
Yes — modern SQLite supports WITH clauses (including recursive CTEs), the full window-function suite (ROW_NUMBER, RANK, LAG, LEAD, running aggregates), UPSERT via ON CONFLICT, and the json functions. That makes it a legitimate practice ground for interview-level SQL, not just beginner SELECTs.
No — each run starts with a fresh, empty database and everything is discarded when the script finishes. That's a feature for practice: keep your CREATE and INSERT statements at the top of the editor and every run is perfectly reproducible. To keep work, save the script itself.
main.sqlsqlnot applicableCREATE TABLE hello (message TEXT);
INSERT INTO hello VALUES ('Hello from SQLite3!');
INSERT INTO hello VALUES ('Welcome to XCODX Online Compiler!');
SELECT * FROM hello;