Help creating an MS SQL Query
Budget: $25 – $50 USD
Hello, I'm somewhat decent at MS Sql but I'm not sure how to go about getting a specific result / building a query. I'm using subqueries to select Sales people and count the number of records in a single table based on specific criteria and grouping by salesperson to get a list of salespeople and then columns beside their name for Total Sales, Total Extended sales, External sales, internal sales so we have just total counts basically per person all on one report. I'm trying to add a few more columns to the results from a different table where I'm not counting records in the table but rather getting all totaled numbers from their phone calls. So one record in the phone call table might show a user, total calls, total outbound, total inbound, etc for the day. I just need that info added beside their name on the main query.