List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:November 12 2006 12:54pm
Subject:Re: Pulling Percentages From Query
View as plain text  
>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

Thread
Pulling Percentages From QueryPaul Nowosielski10 Nov
  • Re: Pulling Percentages From QueryPeter Brawley12 Nov