Query to find statistical informtion

[seducedbycodes]

Hi, just wondering what would be the best way to find statistical information about a customer (ie the number of quotes for that company and the total cost quoted by the company)

There is a table which contains company info and quote info but the number of quotes for a particular company, and total cost is not stored anywhere.
Can this all be done using a query
Thanks in advance

 

[DotNetGnat]

something like this

SELECT CompanyID, CompanyName, COUNT(*) as totalquotes, SUM(Price) as Totalcost FROM Mytable Group By CompanyID

-DNG

 

[lespaul]

modification:

GROUP BY CompanyID, CompanyName

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual