CREATE TABLE projects (code CLOB, name CLOB, hours NUMBER)
CREATE TABLE assignedto (scientist NUMBER, project CLOB)
CREATE TABLE scientists (ssn NUMBER, name CLOB)

What is the sum of hours for projects that scientists with the name Michael Rogers or Carol Smith are assigned to?
SELECT SUM(T2.hours) FROM assignedto AS T1 JOIN projects AS T2 ON T1.project = T2.code JOIN scientists AS T3 ON T1.scientist = T3.ssn WHERE T3.name = 'Michael Rogers' OR T3.name = 'Carol Smith'
SELECT SUM("T2"."hours") FROM "assignedto" "T1" JOIN "projects" "T2" ON "T1"."project" = "T2"."code" JOIN "scientists" "T3" ON "T1"."scientist" = "T3"."ssn" AND ("T3"."name" = 'Carol Smith' OR "T3"."name" = 'Michael Rogers')