Feel a bit of a fool now, you always make it look so simple!
Many thanks, that's perfect
"strawberry" <za*******@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
On Apr 20, 3:46 pm, "Dave" <d...@nospam.co.ukwrote:
>I have a table of score which are 1's and 0's.
How would I go about writing a query to get the percentage of 1's against
the toal number of records?
Many thanks
SELECT (SUM( score ) / COUNT( score )) *100 percentage FROM `scores`