SQL question: figuring percents on totals

SQL question: figuring percents on totals

Hello everybody!!

I have a quick SQL question that I am hoping someone will be able to

I am running a sql report that gives out that looks like the following:

Item  #    Sales                 Cost                     Profit
GP%
------  --------      -------             -----      ----
20            \$36,311.13       \$26,834.46        \$9,476.67   26.10 %
30            \$1,038.12         \$607.22              \$430.90      41.51
%
40            \$538.49            \$281.00              \$257.49      47.82
%
..
..
..
------  ---------- ----------  --------  -------
Total:     \$99,637.10       \$72,678.05       \$26,959.05

Can someone tell me how to figure the gross profit % (sales/profit) for
the totals?
I just can't seem to figure this one out.  I hope that it's possible and
I am just missing something simple.

An e-mailed response would be nice (to the address below), as I will be
out of town next week.

Anthony Valentine

Spenard Builders Supply

This query gives the name of each company with the total number of
jobs per company.  How, please, can I add a column that will show the
percentage of the grand total number of jobs represented by each
company's total?

SELECT CompanyName, COUNT(*) AS JobCount
FROM tblCompany LEFT OUTER JOIN tblJob
ON tblCompany.CompanyID = tblJob.CompanyID
GROUP BY Company Name

TIA,

--David B.