尝试多个CTE和JOIN，例如

Try multiple CTEs and JOIN, e.g.

WITH CTE2017 AS
(
   SELECT NAME, YEAR AS YEAR_2017, INCOME AS INCOME_2017, EXPENSE AS EXPENSE_2017, EMPLOYES AS EMPLOYES_2017 FROM tablename WHERE YEAR='2017'   
),
CTE2016 AS
(
   SELECT NAME, YEAR AS YEAR_2016, INCOME AS INCOME_2016, EXPENSE AS EXPENSE_2016, EMPLOYES AS EMPLOYES_2016 FROM tablename WHERE YEAR='2016'   
)
SELECT CTE2017.NAME, YEAR_2017, INCOME_2017, EXPENSE_2017, EMPLOYES_2017, YEAR_2016, INCOME_2016, EXPENSE_2016, EMPLOYES_2016 FROM CTE2017 JOIN CTE2016 ON CTE2017.NAME=CTE2016.NAME