SQL Query Console 👋
Choose a query:
-- Select a preset query --
── Person ──
View all people
Insert new person
Update person email
Delete person
── PhoneNumber ──
View all phone numbers
Insert new phone number
Delete phone number
── Employee ──
View all employees
Insert new employee
Update employee title
Delete employee
── Customer ──
View all customers
Insert new customer
Update sales rep
Delete customer
── PotentialEmployee ──
View all potential employees
Insert potential employee
Delete potential employee
── Department ──
View all departments
Insert new department
Update department name
Delete department
── JobPosition ──
View all job positions
Insert job position
Delete job position
── Application ──
View all applications
Insert application
Delete application
── Interview ──
View all interviews
Insert interview
Delete interview
── InterviewResult ──
View all interview results
Insert interview result
Delete interview result
── Product ──
View all products
Insert new product
Update product price
Delete product
── PartType ──
View all part types
Insert part type
Delete part type
── Vendor ──
View all vendors
Insert vendor
Delete vendor
── MarketingSite ──
View all marketing sites
Insert marketing site
Delete marketing site
── Sale ──
View all sales
Insert new sale
Update sale site
Delete sale
── Salary ──
View all salaries
Insert salary
Delete salary
── Project ──
View all projects
Insert project
Delete project
Choose a M:N query:
-- Select an M:N table query --
── EmployeeDepartmentHistory ──
View all department histories
Insert department history
Delete department history
── ProductPart ──
View all product parts
Insert product part
Delete product part
── VendorPart ──
View vendor parts
Insert vendor part
Delete vendor part
── SiteStaffing ──
View all site staffing
Insert site staffing
Delete site staffing
── ProjectStaff ──
View project staff
Insert project staff
Delete project staff
Choose a view query:
-- Select a view query --
View1: Avg Monthly Salary per Employee
View2: Passed Interview Rounds per Job
View3: Items Sold by Product Type
View4: Part Cost per Product
Choose a project query:
-- Select a project query --
1. Interviewers for Hellen Cole (job 11111)
2. Marketing Jobs (Jan 2011)
3. Employees with no supervisees
4. Sites with no sales (March 2011)
5. Jobs with no hires
6. Salesmen of all product types > $200
7. Departments with no jobs in Jan-Feb
8. Employees who applied to job 12345
9. Best-selling product type
10. Highest net profit product type
11. Employees in all departments
12. Selected interviewees
13. Info of selected interviewees
14. Highest avg salary
15. Cheapest Cup Vendor
Run Query
Randomize