I have a database that is a list of all transactions done by employees. The table contains the transaction ID, Employee_ID, and terminal. I need to return a single query that will list the number of transactions done in each section of the store. (i.e. terminals 1-4, 5-10). I need to look up how many transactions John Smith did on terminals 1-4 and how many he did on terminals 5-10.
Aucun commentaire:
Enregistrer un commentaire