Which query below will generate the above cross tabulation?

Question $3$ options:

select item name, color, sum$($quantity$)$

from sales

group by cube$($item name, color, clothes$\_$size$)$;

select item name, color, clothes size, sum$($quantity$)$

from sales

group by cube$($item name, color, clothes size$)$;

select item name, color, clothes size, sum$($quantity$)$

from sales

group by cube$($item name, color$)$;

select item name, color, sum$($quantity$)$

from sales

group by cube$($item name, color$)$;