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,
--
Paul
