Why is my code not outputting results? CREATE TEMP TABLE clean$\_$data AS

SELECT

product$\_$id$,$

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

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

$($SELECT ROUND$($AVG$($COALESCE$($NULLIF$($substring$($weight::text, $\text{'}[0-9]+[.]?[0-9]*\text{'}),\text{'}\text{'}),\text{'}0\text{'})$::NUMERIC$),2)$

FROM $($

SELECT weight,

ROW$\_$NUMBER$()$ OVER $($ORDER BY COALESCE$($NULLIF$($substring$($weight::text, $\text{'}[0-9]+[.]?[0-9]*\text{'}),\text{'}\text{'}),\text{'}0\text{'})$::NUMERIC$)$ AS row$\_$num,

COUNT$(*)$ OVER $()$ AS total$\_$rows

FROM products

WHERE weight::text ~ $\text{'}[0-9]+[.]?[0-9]*\text{'}$

$)$ AS sub$1$

WHERE row$\_$num IN $(($total$\_$rows $+1)/2,($total$\_$rows $+2)/2)$

$)$ AS weight$\_$median,

$($SELECT ROUND$($AVG$($COALESCE$($NULLIF$($substring$($price::text, $\text{'}[0-9]+[.]?[0-9]*\text{'}),\text{'}\text{'}),\text{'}0\text{'})$::NUMERIC$),2)$

FROM $($

SELECT price,

ROW$\_$NUMBER$()$ OVER $($ORDER BY COALESCE$($NULLIF$($substring$($price::text, $\text{'}[0-9]+[.]?[0-9]*\text{'}),\text{'}\text{'}),\text{'}0\text{'})$::NUMERIC$)$ AS row$\_$num,

COUNT$(*)$ OVER $()$ AS total$\_$rows

FROM products

WHERE price::text ~ $\text{'}[0-9]+[.]?[0-9]*\text{'}$

$)$ AS sub$2$

WHERE row$\_$num IN $(($total$\_$rows $+1)/2,($total$\_$rows $+2)/2)$

$)$ AS price$\_$median,

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

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

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

FROM products;