I'm trying to pull percentages from a query and
really don't understand how to initiate this.
SELECT COUNT(*) INTO @total FROM venues;
SELECT venueID, COUNT(venueID)*100/@total AS Pct FROM venues GROUP BY
venueID;
PB
Paul Nowosielski wrote:
Dear All,
I'm trying to pull percentages from a query and really don't understand how to
initiate this.
Here is the low down:
I have a list of venues with the number of acts who performed catoragized by
genre.
For example:
venue_id: 23 blues: 117 rock: 34 world_music:57 ( and so on, there are 24
genres listed.)
So my question would be how can I write a query to spit out a result set like:
venue_id:24 blues:34(%) rock:12(%) world music:3(%) comedy: 0(%)
Is this possible?
here is the table structure:
venue_id int(6) PRI 0
Actor int(6) 0
Adult Contemporary int(6) 0
Alternative int(6) 0
Blues int(6) 0
Children's Entertainment int(6) 0
Christian int(6) 0
Classic Rock int(6) 0
Classical int(6) 0
Comedy int(6) 0
Country int(6) 0
Dance int(6) 0
Folk int(6) 0
Holiday int(6) 0
Jazz int(6) 0
Latin int(6) 0
Lecturers & Speakers int(6) 0
Magician int(6) 0
Reggae int(6) 0
Rock int(6) 0
Sports/Athletics int(6) 0
Urban int(6) 0
Variety int(6) 0
World Music int(6) 0
Any help would really be appreciated!
Best,
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.2/528 - Release Date: 11/10/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
