#
# CS 460: Problem Set 2: More practice with SQL
#

#
# For each problem, use a text editor to add the appropriate SQL
# command between the triple quotes provided for that problem's variable.
#
# For example, here is how you would include a query that finds the
# names and years of all movies in the database with an R rating:
#
sample = """
    SELECT name, year
    FROM Movie
    WHERE rating = 'R';
"""

#
# 1. Put your query between the triple quotes found below.
#
query1 = """

"""

#
# 2. Put your query between the triple quotes found below.
#
query2 = """

"""

#
# 3. Put your query between the triple quotes found below.
#
query3 = """

"""

#
# 4. Put your query between the triple quotes found below.
#
query4 = """

"""

#
# 5. Put your query between the triple quotes found below.
#
query5 = """

"""