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

On Apr 20, 3:46 pm, "Dave" <d... [at] nospam.co.uk> wrote:
> 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`

Feel a bit of a fool now, you always make it look so simple!

Many thanks, that's perfect

"strawberry" <zac.carey [at] gmail.com> wrote in message
news:1177082424.673927.305730 [at] q75g2000hsh.googlegroups.com.. .
> On Apr 20, 3:46 pm, "Dave" <d... [at] nospam.co.uk> wrote:
>> 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`
>