LISTADO

Configure the query

Select	None select A,B select A,B,D select D,E,A select E,G,B,C select F,A,B,D	Group by:	None select B,sum(F) group by B select B,avg(G),sum(E) group by A	Scalar functions:	None select F-E select F*G select (F-E)*G	Filter:	None where G < 80 where G < 90 where D <> 'Asia'
Pivot:	None select avg(F) pivot B select sum(G),max(F) pivot D	Offset / limit:	None offset 3 limit 5 limit 4 offset 2	Label / Format:	None select A label A 'Manager Name' select G format G '00%'

Query Table