Exercise 4: Consider the sales: sales (item name, color, clothes size, quantity) Write an SQL query to compute the cube operation on the relation, giving the relation in figure below. Do not use the cube construct. Sign SOLAP A TEMA de al all shirt Boto 15 10 shirt AP SORO all all de all dark shirt all all all rms us; me, to w all Whit WO NOON DOWY pi all all all dark pl while all all NON all Figure 5.21 Portion of data 517 Comidetaples and all all. We have obtained these suples by muting individual tuples with ditt value for color and OB item_name color skirt dark skirt pastel skirt white skirt all dress dark dress pastel dress white dress all shirt dark shirt pastel shirt white shirt all pants dark pants pastel pants white pants all all dark all pastel all white all all clothes size quantity all 8 all 35 all 10 all 53 all 20 all 10 all 5 all 35 all 14 all 7 all 28 all 49 all 20 all 2. all 5 all 27 all 62 all 54 all 48 all 164 Exercise 4: Consider the sales: sales (item name, color, clothes size, quantity) Write an SQL query to compute the cube operation on the relation, giving the relation in figure below. Do not use the cube construct. Sign SOLAP A TEMA de al all shirt Boto 15 10 shirt AP SORO all all de all dark shirt all all all rms us; me, to w all Whit WO NOON DOWY pi all all all dark pl while all all NON all Figure 5.21 Portion of data 517 Comidetaples and all all. We have obtained these suples by muting individual tuples with ditt value for color and OB item_name color skirt dark skirt pastel skirt white skirt all dress dark dress pastel dress white dress all shirt dark shirt pastel shirt white shirt all pants dark pants pastel pants white pants all all dark all pastel all white all all clothes size quantity all 8 all 35 all 10 all 53 all 20 all 10 all 5 all 35 all 14 all 7 all 28 all 49 all 20 all 2. all 5 all 27 all 62 all 54 all 48 all 164