Consider the following table ‘MOVIES’: Table: MOVIES MovieID MovieTitle…

PYQ EMRS TGT/PGT (ESSE) 2025

Consider the following table ‘MOVIES’:

Table: MOVIES

MovieID

MovieTitle

ReleaseDate

ScreenNo

2026103

Chhaava

2025-12-09

S2

2026112

Dragon

2026-02-01

S2

2025125

Ikkis

2026-01-12

S1

Note: Assume the table contains more rows following the same structure.

Write MySQL queries for the following tasks:

(A) Display all details of movies released in the year 2026.

(B) Display all movie details sorted by their ReleaseDate such that the latest movie appears first.

(C) Count the total number of movies whose MovieID (CHAR datatype) starts with the string '2026'.

(D) Display each ScreenNo along with the total number of movies assigned to that screen.

Attempted by 40 students.

Sign up free to check your answer

Sign up free

Explore the full course: Emrs Cs Tier 2

Loading lesson…