我想我理解了你想要什么，但是你想要的输出（你发布的截图）不匹配。例如，McGregor有两个“红色”行，分别标记了汽车和四轮驱动，而你的输出显示“是”只设置为汽车。为什么？我不能运行你发布的查询，因为它是无效的，因此返回 nothing。
示例数据：

SQL> select * From purchased;

CUSTOMER_ID LAST_NAME  FIRST_NAME COLOU CAR SUV TRUCK FOURWD
----------- ---------- ---------- ----- --- --- ----- -------
         50 Smith      John       Black     Yes
         50 Smith      John       Red   Yes
         50 Smith      John       Red           Yes   Yes
         50 Smith      John       Red   Yes
         20 McGregor   Katie      Blue  Yes           Yes 
         20 McGregor   Katie      Red   Yes                   --> car is red
         20 McGregor   Katie      Black     Yes
         20 McGregor   Katie      Red   Yes           Yes     --> car and 4WD are red
         11 Yang       Karen      Red   Yes
         11 Yang       Karen      Red       Yes
         90 Wilkins    Melissa    Black Yes
         90 Wilkins    Melissa    Red           Yes   Yes
         90 Wilkins    Melissa    Blue  Yes     Yes
         90 Wilkins    Melissa    Grey
        135 Barnes     Tom        Red   Yes     Yes   Yes
        135 Barnes     Tom        Blue  Yes
        135 Barnes     Tom        Black         Yes

17 rows selected.

查询，我理解为：

SQL> select customer_id, last_name, first_name,
  2    max(case when colour = 'Red' then nvl(car, 'No') end) as car,
  3    max(case when colour = 'Red' then nvl(suv, 'No') end) as suv,
  4    max(case when colour = 'Red' then nvl(truck, 'No') end) as truck,
  5    max(case when colour = 'Red' then nvl(fourwd, 'No') end) as fourwd
  6  From purchased
  7  where colour = 'Red'
  8  group by customer_id, last_name, first_name
  9  /

CUSTOMER_ID LAST_NAME  FIRST_NAME CAR SUV TRUCK FOURWD
----------- ---------- ---------- --- --- ----- -------
         50 Smith      John       Yes No  Yes   Yes
         20 McGregor   Katie      Yes No  No    Yes
         11 Yang       Karen      Yes Yes No    No
         90 Wilkins    Melissa    No  No  Yes   Yes
        135 Barnes     Tom        Yes No  Yes   Yes

SQL>