I need help converting this query in english into SQL form and write run them on
ID: 3929437 • Letter: I
Question
I need help converting this query in english into SQL form and write run them on access. Underneath is the data that i am using for conversion.
Query
For each theatre, find the lowest and highest ratings of the movies played in this theatre. Output a table consisting of three columns: Theatre, Lowest, Highest.
Movies
Title
Year
Runtime
Rating
Django Unchained
2012
165
8.5
Goodfellas
1990
146
8.8
Pulp Fiction
1994
154
9
The Departed
2006
151
8.5
Showtimes
Theatre
Title
Day
Showtime
Landmark
Django Unchained
Sat
6:00:00 PM
Music Box
Django Unchained
Wed
8:40:00 PM
The Gene Siskel
Django Unchained
Sun
3:30:00 PM
The Gene Siskel
Django Unchained
Sun
11:50:00 AM
Century 12
Goodfellas
Thu
12:30:00 PM
Century 12
Goodfellas
Fri
7:00:00 PM
Century 12
Pulp Fiction
Thu
10:00:00 AM
Landmark
Pulp Fiction
Fri
6:00:00 PM
Music Box
Pulp Fiction
Fri
6:20:00 PM
Landmark
The Departed
Fri
5:30:00 PM
Music Box
The Departed
Wed
5:30:00 PM
The Gene Siskel
The Departed
Sat
5:30:00 PM
Movies
Title
Year
Runtime
Rating
Django Unchained
2012
165
8.5
Goodfellas
1990
146
8.8
Pulp Fiction
1994
154
9
The Departed
2006
151
8.5
Showtimes
Theatre
Title
Day
Showtime
Landmark
Django Unchained
Sat
6:00:00 PM
Music Box
Django Unchained
Wed
8:40:00 PM
The Gene Siskel
Django Unchained
Sun
3:30:00 PM
The Gene Siskel
Django Unchained
Sun
11:50:00 AM
Century 12
Goodfellas
Thu
12:30:00 PM
Century 12
Goodfellas
Fri
7:00:00 PM
Century 12
Pulp Fiction
Thu
10:00:00 AM
Landmark
Pulp Fiction
Fri
6:00:00 PM
Music Box
Pulp Fiction
Fri
6:20:00 PM
Landmark
The Departed
Fri
5:30:00 PM
Music Box
The Departed
Wed
5:30:00 PM
The Gene Siskel
The Departed
Sat
5:30:00 PM
Explanation / Answer
select min(m.rating),max(m.rating),t.theatre from ShowTimes t,Movies m where t.theatre=m.title groupby t.Title
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.