• Hmm.

    What do you get from the following queries?

    SELECT * FROM Enrollment WHERE Grade IN ('PK','KG','01','02')
    SELECT Grade, COUNT(*) FROM Enrollment GROUP BY Grade

    Thomas Rushton
    blog: https://thelonedba.wordpress.com