在下列SELECT语句中，正确的是________。

A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资

B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资

C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表

D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表

E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资

A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资

B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资

C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表

D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表

E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资

A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资

B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资

C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表

D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表

E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资

A.SELECT职工号, 姓名FROM职工 WHERE工资= MAX(工资)  

B.SELECT职工号, 姓名FROM职工 WHERE工资=（SELECT MAX(工资) FROM职工）

C.SELECT职工号, 姓名, 工资FROM职工 WHERE工资=MAX(工资)

D.SELECT职工号, 姓名,MAX(工资) FROM职工WHERE工资=MAX(工资)

A.SELECT职工号, 姓名FROM职工 WHERE工资= MAX(工资)

B.SELECT职工号, 姓名FROM职工 WHERE工资=（SELECT MAX(工资) FROM职工）

C.SELECT职工号, 姓名, 工资FROM职工 WHERE工资=MAX(工资)

D.SELECT职工号, 姓名,MAX(工资) FROM职工WHERE工资=MAX(工资)

A.SELECT 性别 , COUNT(*)AS 人数 FROM 职工 WHERE 工资 <800 ORDER BY 性别

B.SELECT 性别 , COUNT(*)AS 人数 FROM 职工 WHERE 工资 <800 GROUP BY 性别

C.SELECT 性别 , SUM(*) AS 人数 FROM 职工 WHERE 工资 < 800 GROUP BY 性别

D.SELECT 性别 , AVG(*) AS 人数 FROM 职工 WHERE 工资< 800 GROUP BY 性别