After the data source is opened and accessed, let~{!/~}s move on to look at how to further compute data with a series offilter,sort,group
Syntax: SELECT select_list FROM T WHERE search_condition Parameter: search_condition Filtering condition on table T Examfilter, where
Syntax: SELECT … ON D AS A WHERE … FROM T BY T.F..... Parameter: D Dimension A Alias of dimension D and AS operator aftefilter, dimension