在MySQL中,运行以下 SELECT 查询时:
SELECT ID FROM ( SELECT ID, name FROM ( SELECT * FROM employee ) );
出现错误信息 "每个派生表必须有自己的别名"。以下哪项是解决该错误的最佳方案?( )
SELECT ID FROM ( SELECT ID AS SECOND_ID, name FROM ( SELECT * FROM employee ) );
SELECT ID FROM ( SELECT ID, name AS NAME FROM ( SELECT * FROM employee ) );
SELECT ID FROM ( SELECT ID, name FROM ( SELECT * FROM employee ) AS T ) AS T;
SELECT ID AS FIRST_ID FROM ( SELECT ID, name FROM ( SELECT * FROM employee ) );