human
Schema:
works_on (Essn, Pno, Hours)
employee (Fname, Minit, Lname, Ssn, Bdate, Address, Sex, Salary, Super_ssn, Dno)
department (Dname, Dnumber, Mgr_ssn, Mgr_start_date)
project (Pname, Pnumber, Plocation, Dnum)
dependent (Essn, Dependent_name, Sex, Bdate, Relationship)
dept_locations (Dnumber, Dlocation)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me all the departments
assistant
SELECT * FROM department ;