Non-standard fields
You may occasionally receive a dataset with poorly named fields. Ideally, you would fix these, but you can work around it with some added punctuation in this instance.
A sample query and schema have been provided; imagine you need to be able to run it with a non-standard field name. Select the multiple-choice answer that would correctly fill in the blank to return both a film's id and its number of Facebook likes for all reviews:
SELECT film_id, ___
FROM reviews;

This exercise is part of the course
Intermediate SQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
