SQL Compiler - LearnHub Notice: session_start(): Ignoring session_start() because a session is already active in /home/sites/34a/4/4a7caa9d1d/public_html/ems/internship/pages/sql-compiler.php on line 171
SQL CompilerSQLWelcome, Developer
SQL Editor
SQLite via SQL.js
Query Results
Initializing SQL Database
Loading SQL.js library...
This may take a moment
SQL Query Examples
Create Table
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
age INTEGER,
grade TEXT,
email TEXT UNIQUE
);
SELECT name, age, grade
FROM students
WHERE age >= 20 AND grade = 'A'
ORDER BY age;
Aggregation
SELECT
grade,
COUNT(*) as student_count,
AVG(age) as average_age,
MIN(age) as youngest,
MAX(age) as oldest
FROM students
GROUP BY grade
ORDER BY grade;
Update & Delete
-- Update a record
UPDATE students
SET grade = 'A+'
WHERE name = 'Alice Johnson';
-- Delete records
DELETE FROM students
WHERE age < 20;