ODBC > Sample SQL Query to Show the Number of Records per Transaction Type

Question: The ODBC user needs to query the details of the TRANSACTIONS table via ODBC. The user will create a report that will show the number of transactions that are currently in their account.
 
Answer:
 
1. Sample query shown below:
// The query below shows the number of records per transaction type.
SELECT
 COUNT(*), TRANSACTION_TYPE
FROM
 TRANSACTIONS
GROUP BY
 TRANSACTION_TYPE
ORDER BY
 TRANSACTION_TYPE ASC;