This sample data table contains employee data, such as, employee name, email address, phone number, address, work site, department, date of hire, salary, date of birth, etc.
View Database
Sample Questions |
SQL Results |
Show me all employees in New York? |
SELECT hrx.fname, hrx.lname FROM nlp.hrx where hrx.work_site = 'new york' Limit 30; |
Show me the name, phone number and hire date of all employees who were hired before 12/24/1999, |
SELECT hrx.lname, hrx.fname, hrx.work_phone, hrx.hire_date FROM nlp.hrx where hrx.hire_date<'1999-12-24' Limit 30; |
How many children does Thomas Axen have? |
SELECT hrx.number_of_children FROM nlp.hrx where hrx.fname = 'thomas' AND hrx.lname = 'axen'; |
What is the phone number and home address of Vazwer Mizpol? |
SELECT hrx.work_phone, hrx.home_address FROM nlp.hrx where hrx.fname = 'vazwer' AND hrx.lname = 'mizpol'; |