Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise