You can designate one column as A and another as D within the same query. If you want the sorting order (ascending or descending) to be different from the column order, you can combine a letter ( A or ...

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...