Good look here I have a question, because I have an Employee Table and a Sales Table, and for sale I have types of documents (Invoice Bill, etc), then the query I want to make in Sql Server 2014 is that I list the employees and show me the number that has been issued by said employee of each type of document and also their respective total amounts. For example: employee A issued 2 invoices 250.00 issued 3 tickets 300.00 employee B issued 5 invoices 1000.00 issued 1 ticket 200.00
I do not know if it could be done, if you help me please.