SELECT

"product$\_$id$",$

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

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

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

COALESCE$("$price$",$ PERCENTILE$\_$CONT$(0\mathrm{.}5)$ WITHIN GROUP $($ORDER BY "price"$)$::numeric 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

products;