SQL Foundation Three (example)

-------------------Further filter the results of the grouping statistics (with the HAVING clause used)------------------------------Select *  fromstudent2010--1. Query the number of faculties in the Qypt08class table, showing only the records of more than 400 peopleSelectYxsum(RS) fromQypt08classGroup  byYx having sum(RS)> - --2. The number of elective courses in the Stucou table shows a record of less than 30 (showing Couno and corresponding people)SelectCouno,Count(*) fromStucouGroup  byCouno having Count(*)< ---3. XYMC, ZYMC, BJMC and RS (number of persons) for classes with more than 70 people in the student2010 tableSelectXYMC,ZYMC,BJMC,Count(*) fromstudent2010Group  byXymc,zymc,bjmc having Count(*)> -

Having clauses used

SQL Foundation Three (example)