Query 1 (2 pts)

List all movies played in Landmark or Music Box. Output only titles and eliminate duplicates.

Query 2 (2 pts)

List all stars born after 1960. Order them by their birthdate in ascending order. Output their first names, last names, and birthdates.

Query 3 (2 pts)

List all courses taught in Fall 2014. Output only CourseId and Name. Use product or join.

Query 4 (2 pts)

Find all students who have an A grade. Output only their first and last names. Eliminate duplicates. use product or join.

Query 5 (2 pts)

Find all instructors who teach in Fall 2014. Output only their first and last names. Eliminate duplicates. Use product or join.

Query 6 (2 pts)

Find all movies played in Evanston. Output only their titles and eliminate duplicates. Use product or join.

 

 

    • 5 years ago
    A+ Work
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      cs_3atabasesystems.zip