Des alias qui cassent la requête

Question

Lesquelles de ces requêtes sur la table film échouent avec une erreur ? Choisissez toutes les bonnes réponses.

Answer 1

SELECT title AS t FROM film ORDER BY t;

Answer 2

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

Answer 3

SELECT title AS Film title FROM film;

Answer 4

SELECT title AS "Film title" FROM film;

Answer 5

SELECT f.title FROM film AS f;

Answer 6

SELECT film.title FROM film AS f;

Answer 7

SELECT title film_title FROM film;

Pratique