Consider the tables STUDENT and CLASSTEACHER provided below: Table:…

PYQ EMRS TGT/PGT (ESSE) 2025

Consider the tables STUDENT and CLASSTEACHER provided below:

Table: STUDENT

AdmissionNo

Name

DOB

ClassSec

TotalMarks

2026103

Sameer Jha

2013-09-12

6B

115

2026112

Sonika Jain

2014-01-08

6A

406

2026125

Zoya Javed

2013-11-08

6A

358

Table: CLASSTEACHER

ClassSec

CTName

RoomNo

6A

Gurpreet Kaur

112

6B

KJ Jacob

106

Note: Both tables include more relevant rows.

Write MySQL queries for the following tasks:

(A) Display the Name of all the students along with their respective Class Teacher’s name (CTName).

(B) Display each Class Teacher’s name (CTName) along with the total count of students in their respective ClassSec.

(C) Display each Class Teacher’s name (CTName) along with the average TotalMarks of their ClassSec, sorted by ClassSec in ascending order.

(D) Display the Name, DOB, ClassSec, and CTName of all students born in the year 2013 or earlier.

Attempted by 44 students.

Sign up free to check your answer

Sign up free

Explore the full course: Emrs Cs Tier 2

Loading lesson…