<div>
<br />
select sum(total), sum(num), avg(average)<br />
from <br />
(<br />
select rep_name, sum(totalprice) as total, count(*) as num, sum(totalprice)/count(*) as average<br />
from order_entry oe inner join employees e<br />
on oe.sales_rep_emp_number = e.employee_number<br />
-- where clauses that filter by date and by employee criteria<br />
group by oe.sales_rep_emp_number, e.rep_name<br />
) a 
</div>


<div>
momi_sabaq, I fixed the typos on spelling &quot;distinct&quot;, and it is perfect.<br />
<br />
Thank you both for your input!
</div>


<div>
My bad chapmandew. &nbsp;I pasted in the first one, it worked, I moved on.<br />
<br />
The example I'm trying it out on is substantially smaller than the one I need to use in production. &nbsp;So small in fact, the first solution that I accepted barely takes more than a second to complete.<br />
<br />
Your solution seems to return before I release the &quot;execute&quot; key. &nbsp;This difference will be significant when I glue everything back together.<br />
<br />
Thanks for posting your follow-up. &nbsp;And my apologies for not trying both solutions first. &nbsp;It won't happen again.<br />

</div>


<div>
Although I think this was the first line I needed:<br />
<br />
select sum(total), count(num), avg(total)<br />
-- the rest, as is
</div>


<div>
<div class="content wysiwyg-content">
The query below returns sales statistics from the 'order_entry' table. &nbsp;With one row for each sales rep, I get the sum of sales, the count of the number of sales, and the average amount of each sale. &nbsp;I have removed some additional where clauses to simplify this question. &nbsp;<br />
<br />
What I need to return instead is (a single row): the sum of sales, the count of the number of sales reps, and the average amount of sales per rep.<br />
<br />
Thanks for any help-<br />
<br />
select rep_name, sum(totalprice) as total, count(*) as num, sum(totalprice)/count(*) as average<br />
from order_entry oe inner join employees e<br />
on oe.sales_rep_emp_number = e.employee_number<br />
-- where clauses that filter by date and by employee criteria<br />
group by oe.sales_rep_emp_number, e.rep_name
</div>
</div>


The query below returns sales statistics from the 'order_entry' table.  With one row for each sales rep, I get the sum of sales, the count of the number of sales, and the average amount of each sale.  I have removed some additional where clauses to simplify this question.  

What I need to return instead is (a single row): the sum of sales, the count of the number of sales reps, and the average amount of sales per rep.

Thanks for any help-

select rep_name, sum(totalprice) as total, count(*) as num, sum(totalprice)/count(*) as average
from order_entry oe inner join employees e
on oe.sales_rep_emp_number = e.employee_number
-- where clauses that filter by date and by employee criteria
group by oe.sales_rep_emp_number, e.rep_name

ht get average sales per sales rep? (MS SQL 2000)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.