Show the denomination shared by more than one school?
SELECT Denomination FROM school GROUP BY Denomination HAVING COUNT ( * )  > 1
denomination shared by more than one school refers to GROUP BY Denomination HAVING COUNT(*) > 1;