Selecting films by year and language
A university film club is creating a watch list. They're interested in English-language movies released during the 1980s, and they want to include all English films from 1995, too (one of the club members is fond of that specific year).
You've decided you'll help them extract the right titles from the database, given your familiarity with it!
Toto cvičení je součástí kurzu
Intermediate SQL Querying with AI
Pokyny k cvičení
- Formulate a prompt that asks for all English-language film titles with years from the 1980s or from 1995.
Interaktivní cvičení na vyzkoušení si v praxi
Vyzkoušejte si toto cvičení dokončením tohoto ukázkového kódu.
SELECT title
FROM films;