Playground
Experiment with relational algebra expressions
Quick Reference
Click to insert
Enter an expression and click Evaluate to see results
select salary > 70000 (Employee)
project name, salary (Employee)
Employee join Department
Available Datasets
(Employee, Department)
Employee(20 tuples)
idnumber | namestring | salarynumber | dept_idnumber | hire_datestring |
|---|---|---|---|---|
| 1 | Alice Johnson | 75000 | 10 | 2020-01-15 |
| 2 | Bob Smith | 82000 | 10 | 2019-03-22 |
| 3 | Charlie Brown | 68000 | 20 | 2021-06-10 |
| 4 | Diana Prince | 95000 | 20 | 2018-09-05 |
| 5 | Eve Davis | 71000 | 30 | 2020-11-20 |
Showing 5 of 20 tuples
Department(4 tuples)
idnumber | namestring | budgetnumber | locationstring |
|---|---|---|---|
| 10 | Engineering | 500000 | Building A |
| 20 | Sales | 350000 | Building B |
| 30 | Marketing | 280000 | Building C |
| 40 | HR | 150000 | Building A |