Aliases That Break a Query

Question

Which of these queries against the film table fail with an error? Choose all that apply.

Answer 1

SELECT title AS t FROM film WHERE t LIKE 'A%';

Answer 2

SELECT title film_title FROM film;

Answer 3

SELECT title AS Film title FROM film;

Answer 4

SELECT film.title FROM film AS f;

Answer 5

SELECT title AS "Film title" FROM film;

Answer 6

SELECT f.title FROM film AS f;

Answer 7

SELECT title AS t FROM film ORDER BY t;

Practice