CREATE OR REPLACE TEMPORARY VIEW PeopleSavings AS

SELECT

firstName,

lastName,

year(birthDate) as birthYear,

salary,

salary * 0.2 AS savings

FROM

People10M;