Fix code CREATE VIEW clean$\_$data AS

SELECT

product$\_$id$,$

COALESCE$($product$\_$type, 'Unknown'$)$ AS product$\_$type,

COALESCE$($brand$,$ 'Unknown'$)$ AS brand,

COALESCE$($weight$,($SELECT ROUND$($PERCENTILE$\_$CONT$(0\mathrm{.}5)$ WITHIN GROUP $($ORDER BY weight$)),2)$ FROM products$))$ AS weight,

COALESCE$($price$,($SELECT ROUND$($PERCENTILE$\_$CONT$(0\mathrm{.}5)$ WITHIN GROUP $($ORDER BY price$)),2)$

FROM products$))$ AS price,

COALESCE$($average$\_$units$\_$sold, $0)$ AS average$\_$units$\_$sold,

COALESCE$($year$\_$added, $2022)$ AS year$\_$added,

COALESCE$($stock$\_$location, 'Unknown'$)$ AS stock$\_$location

FROM $($

SELECT $*,$

NTILE$(100)$ OVER $($ORDER BY weight$)$ AS weight$\_$percentile,

NTILE$(100)$ OVER $($ORDER BY price$)$ AS price$\_$percentile

FROM products

$)$

WHERE weight$\_$percentile BETWEEN $45$ AND $55$

AND price$\_$percentile BETWEEN $45$ AND $55$;