Filtering in or out
A film blogger is collaborating on a marketing campaign and is planning a series of articles to engage cinema enthusiasts with fresh perspectives on movie history. For the first piece, they want to highlight milestone years. For the second piece, they are focusing on world cinema, they've already done pieces on English and Spanish films but need help to spotlight movies made in other languages.
Your task is to help the blogger by retrieving the right sets of films for both projects.
This exercise is part of the course
Intermediate SQL with AI
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT *
FROM films;