SELECT device_id AS user_infos_example
FROM user_profile
LIMIT 2;

其实还有一种视图写法,但是该题目不给创建视图的权限。。雷姆

CREATE VIEW ssd AS
SELECT device_id AS user_infos_example
FROM user_profile;
SELECT * FROM ssd
LIMIT 2;