I would like to group data of
Table1 with a query that should give me
Table2 as output.
Table2.FieldD is the count of
Table1.FieldB where the grouping criteria is fulfilled.
The criteria is this:
Group1 is made by all the record of
Table1.FieldA starts with "AK" or "KN".
Group2 is the complementary of