Note the colours with no matching bricks return null. To show zero instead, you can use NVL or coalesce. This needs to go around the whole subquery.
#Oracle
#Scalar_Subqueries_2