select
select {*|column[::type][.join][, column[::type][.join]]|count(*)} from table_name [order by column[::type][.join][, column[::type][.join]]]