A SELECT Tipo, Σ Valor/Number(Tipo); FROM Item WHERE Tipo IS ‘S% COUNT Tipo;
B ELECT Tipo, Σ Valor/Number(Tipo) FROM Item ORDER BY Tipo ( ‘S%’);
C SELECT Tipo, AVG (Valor) FROM Item GROUP BY Tipo (‘S%’);
D SELECT Tipo, AVG (Valor) FROM Item WHERE Tipo LIKE ‘S%’ GROUP BY Tipo;
E SELECT Tipo, Total (Valor)/Number (Tipo) FROM Item WHERE Tipo START ‘S%’ HAVING Tipo IN GROUP;