查询老师的姓名、职称和年龄，并重命名，以下哪个方法是正确的?
A. Select * From Teacher
B. SELECT Teachername ,Profession ,Brith FROM Teacher
C. SELECT Teachername ,Profession ,2020-YEAR(Brith) FROM Teacher
D. SELECT Teachername as 姓名 ,Profession as 职称 ,2020-YEAR(Brith) as 年龄 FROM Teacher
从XKGL数据库中的student表中选取学号、姓名、性别的操作，以下操作代码正确的是：
A. USE [xkgl]GOSELECT [StudentID] AS 学号,[StudentName] AS 姓名,[Sex] AS 性别 FROM [dbo].[Student]GO
B. USE [xkgl]GOSELECT [StudentID],[StudentName],[Sex] FROM [dbo].[Student]GO
C. USE xkglGOSELECT StudentID,StudentName,Sex FROM StudentGO
D. USE xkglGOSELECT StudentID,StudentName,ClassID FROM StudentGO
微信支付 
支付宝支付