One SQL query for

a. A column to be called sale_price_zscore that represents, for each sale/row, the Z-Score of SALE_PRICE of that row as normalized against the entirety of the dataset b. A column to be called sale_price_zscore_neighborhood that represents, for each sale/row, the Z-Score of SALE_PRICE but as normalized based on the NEIGHBORHOOD and BUILDING_CLASS segment to which that row belongs