I have a table in mssql database name studentstb where students enrolment records are kept.this is the studentstb
I have another table which contains the students classrooms named classtb.class table contains the classrooms in the school
I want to write an sql statement that will give me a summary of the two tables as seen in image threeEnrollment summary
