会让查询出错的别名

Question

下列针对 film 表的查询中，哪些会报错？请选出所有符合的选项。

Answer 1

SELECT film.title FROM film AS f;

Answer 2

SELECT f.title FROM film AS f;

Answer 3

SELECT title AS Film title FROM film;

Answer 4

SELECT title AS t FROM film ORDER BY t;

Answer 5

SELECT title film_title FROM film;

Answer 6

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

Answer 7

SELECT title AS "Film title" FROM film;

练习