The underlined attribute(s) are the primary key

Using the following tables create SQL queries:

1. Find the name and the phone number of the theaters that show the maximum number of movies. Make sure your query works when there is a tie between several theaters.

2. Find the average ratings of all movies playing at each theater. Display the theater name and the computed rating. Order the results ascending by rating

Table 1: Theatres Name City State Zip Phone Table 2: Movies Title Rating Rating Length ReleaseDate Release Date Table 3: ShownAt TheatreName Movie Title