Consider the two tables ‘MOVIES’ and ‘SCREENS’ provided below. Table: MOVIES…
PYQ EMRS TGT/PGT (ESSE) 2025
Consider the two tables ‘MOVIES’ and ‘SCREENS’ provided below.
Table: MOVIES
MovieID | MovieTitle | ReleaseDate | ScreenNo |
|---|---|---|---|
2026103 | Chhaava | 2025-12-09 | S2 |
2026112 | Dragon | 2026-02-01 | S2 |
2025125 | Ikkis | 2026-01-12 | S1 |
Table: SCREENS
ScreenNo | ScreenSize | TotalSeats |
|---|---|---|
S1 | 60 | 380 |
S2 | 70 | 540 |
Note: Both tables include more relevant rows.
Write MySQL queries to perform the specified tasks:
(A) Display the MovieTitle and the TotalSeats of the screen assigned to each movie.
(B) Display the MovieTitle and ScreenSize of all movies, sorted in descending order of their TotalSeats.
(C) Display the ScreenNo, TotalSeats, and the total count of movies assigned to each screen.
(D) Display each unique year from the ReleaseDate along with the sum of TotalSeats available for movies released in those years.
Attempted by 54 students.
Sign up free to check your answer
Sign up freeLoading lesson…

