Films with missing data
The finance team is reviewing film performance reports. During their checks, they notice that some gross and budget records are incomplete. Since this missing information could affect their analysis, they need a list of all films where both values are not recorded to prioritize these for investigation.
Toto cvičení je součástí kurzu
Intermediate SQL Querying with AI
Pokyny k cvičení
- Set up a prompt that retrieves all films with missing values for both gross and budget.
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 *
FROM films;