SQLMentor // sql editor

SQL Editor

// run queries in-browser · Oracle HR schema pre-loaded · Ctrl+Enter to execute

Query
Results
Run a query to see results…
Quick examples
Oracle HR Schema — available tables
employees
employee_id · first_name · last_name · email · phone_number · hire_date · job_id · salary · commission_pct · manager_id · department_id
departments
department_id · department_name · manager_id · location_id
jobs
job_id · job_title · min_salary · max_salary
locations
location_id · street_address · postal_code · city · state_province · country_id
countries
country_id · country_name · region_id
regions
region_id · region_name
job_history
employee_id · start_date · end_date · job_id · department_id
customers
customer_id · name · city
orders
order_id · customer_id · order_date · total