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 freeLoading lesson…

