I need help converting this query in english into SQL form a

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

Solution

select min(m.rating),max(m.rating),t.theatre from ShowTimes t,Movies m where t.theatre=m.title groupby t.Title

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 t
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 t
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 t

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site