SQL Online Editor – Write, Run & Test SQL in Browser

SQL Online Editor – anukulsaini.com

✏️ SQL Editor

Ln 1, Col 1 0 chars

-- Online SQL Editor – anukulsaini.com
-- Use the editor to create tables, insert data and run queries.

CREATE TABLE employees (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  department TEXT,
  salary REAL,
  joined_date TEXT
);

CREATE TABLE departments (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  manager TEXT,
  budget REAL
);

INSERT INTO departments VALUES (1, 'Engineering', 'Anukul Saini', 850000);
INSERT INTO departments VALUES (2, 'Product',     'Riya Singh',   620000);
INSERT INTO departments VALUES (3, 'Design',      'Arjun Mehta',  430000);
INSERT INTO departments VALUES (4, 'Marketing',   'Priya Nair',   380000);

INSERT INTO employees VALUES (1, 'Anukul Saini', 'Engineering', 95000, '2021-03-15');
INSERT INTO employees VALUES (2, 'Riya Singh',   'Product',     88000, '2020-07-01');
INSERT INTO employees VALUES (3, 'Arjun Mehta',  'Design',      72000, '2022-01-10');
INSERT INTO employees VALUES (4, 'Priya Nair',   'Marketing',   65000, '2021-11-20');
INSERT INTO employees VALUES (5, 'Vikram Raj',   'Engineering', 91000, '2019-05-05');
INSERT INTO employees VALUES (6, 'Sneha Patel',  'Product',     83000, '2023-02-28');
INSERT INTO employees VALUES (7, 'Karan Joshi',  'Design',      69000, '2022-08-14');
INSERT INTO employees VALUES (8, 'Divya Kapoor', 'Engineering', 97000, '2020-12-01');

SELECT * FROM employees;