A+ Work





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.