human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
show the name and hours for each project.
assistant
SELECT name , hours FROM projects;
human
how many projects are there?
assistant
SELECT COUNT( * ) FROM projects ;