SQL Wright

Database Schema

Paste your SQL schema below. The more detailed it is, the better the generated query will be.

CREATE TABLE employees (
  employee_id INT PRIMARY KEY,
  first_name VARCHAR(50),
  last_name VARCHAR(50),
  email VARCHAR(100),
  phone_number VARCHAR(20),
  hire_date DATE,
  job_id VARCHAR(10),
  salary DECIMAL(10, 2),
  manager_id INT,
  department_id INT
);

CREATE TABLE departments (
  department_id INT PRIMARY KEY,
  department_name VARCHAR(50),
  location_id INT
);

Example Queries

Generate or view example queries based on your schema.

Click the button to generate example queries.

Query Generator

Describe the data you need in plain English.

Your generated SQL will appear here.