percentage in sql query

[Dave]

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

[strawberry]

Post by Dave
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`

[Dave]

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

Many thanks, that's perfect

Post by strawberry

Post by Dave
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`