human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
How many number if scientist belong to project AeH1
assistant
SELECT COUNT( * ) FROM projects AS T1 JOIN assignedto AS T2 ON T1.code = T2.project WHERE T1.Code = 'AeH1';
human
How about project Ast3, how many scientists?
assistant
SELECT COUNT( * ) FROM projects AS T1 JOIN assignedto AS T2 ON T1.code = T2.project WHERE T1.Code = 'Ast3';
human
How about project AeH3
assistant
SELECT COUNT( * ) FROM projects AS T1 JOIN assignedto AS T2 ON T1.code = T2.project WHERE T1.Code = "AeH3" ;