012zsco.sql

select 顧客番号, 年月, 
(cast((売上数量) as float) - avg(売上数量) over(partition by 顧客番号)) / stddev_pop(売上数量) over(partition by 顧客番号)) as 売上数量z, 
(cast((平均単価) as float) - avg(平均単価) over(partition by 顧客番号)) / stddev_pop(平均単価) over(partition by 顧客番号)) as 平均単価z 
from データベース名.テーブル名 
;