|
跟着香帅学SQL{:soso_e152:}- HDR=NO
- 第一题:
- SELECT F1 AS 部门, F2 AS 员工, F3 AS 第一季度金额, F4 AS 第二季度金额, F5 AS 第三季度金额, F6 AS 第四季度金额
- FROM [查询练习$A3:F11]
- 第二题:
- SELECT F1 AS 部门, F2 AS 员工, F3 AS 第一季度金额, F4 AS 第二季度金额, F5 AS 第三季度金额, F6 AS 第四季度金额
- FROM [查询练习$A3:F11]
- WHERE F1="A"
- 第三题:
- SELECT F1 AS 部门, SUM(F3) AS 第一季度合计金额
- FROM [查询练习$A3:F11]
- GROUP BY F1
- 第四题:
- SELECT F1 AS 部门, F2 AS 员工, F3 AS 第一季度金额, F4 AS 第二季度金额, F5 AS 第三季度金额, F6 AS 第四季度金额
- FROM [查询练习$A3:F11]
- WHERE F5>700000
- 第五题:
- SELECT F1 AS 部门, MAX(F6) AS 第四季度最大金额
- FROM [查询练习$A3:F11]
- GROUP BY F1
- 第六题:
- SELECT F1 AS 部门, F2 AS 员工, F3 AS 第一季度金额, F4 AS 第二季度金额, F5 AS 第三季度金额, F6 AS 第四季度金额
- FROM [查询练习$A3:F11]
- ORDER BY F3+F4+F5+F6 DESC
复制代码 |
|