#
# CS 460: Problem Set 1, SQL Programming Problems
#

#
# 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';
"""

#
# Problem 4. Put your SQL command between the triple quotes found below.
#
problem4 = """

"""

#
# Problem 5. Put your SQL command between the triple quotes found below.
#
problem5 = """

"""

#
# Problem 6. Put your SQL command between the triple quotes found below.
#
problem6 = """

"""

#
# Problem 7. Put your SQL command between the triple quotes found below.
#
problem7 = """

"""

#
# Problem 8. Put your SQL command between the triple quotes found below.
#
problem8 = """
           
"""

#
# Problem 9. Put your SQL command between the triple quotes found below.
#
problem9 = """
           
"""

#
# Problem 10. Put your SQL command between the triple quotes found below.
#
problem10 = """
            
"""

#
# Problem 11. Put your SQL command between the triple quotes found below.
#
problem11 = """
            
"""

#
# Problem 12. Put your SQL command between the triple quotes found below.
#
problem12 = """
            
"""

#
# Problem 13. Put your SQL command between the triple quotes found below.
#
problem13 = """
            
"""

#
# Problem 14. Put your SQL command between the triple quotes found below.
#
problem14 = """
            
"""

#
# Problem 15. Put your SQL command between the triple quotes found below.
#
problem15 = """
            
"""