select count (*) from pacientes

SELECT nomem

FROM medicos

WHERE codm NOT IN

(SELECT codm

FROM consultas

WHERE codp IN

(SELECT C.codp

FROM medicos M, consultas C, pacientes P

WHERE M.especialidade = “obstetrícia” and

M.codm = C.codm and C.codp = P.codp))

SELECT data, count(*)

FROM Consultas

Group by data

SELECT count(especialidade)

FROM Medicos M

Group by especialidade

SELECT data, count(*)

FROM Consultas C, médicos M

WHERE C.codm = M.Codm and M. Especialidade = “Pediatria”

Group by data