Posted by IchBin on 10/02/05 11:31

laredotornado@zipmail.com wrote:
> Hello, I'm using MySQL 3.23. If I have a table with two columns
>
> REGION VARCHAR(16),
> SALES FLOAT UNSIGNED
>
> How can I write an SQL SELECT statement to give me the sales per state
> -- where the "REGION" column would hold the two-letter state
> abbreviation -- and sales per everything else. So a possible result
> set would look like
>
> Region Total_Sales
> --------- ----------------
> CA 10000.00
> TX 5000.00
> International 3000.00
> NJ 1000.00
>
> Your help is much appreciated - Dave
>
Try

SELECT REGION, SUM(SALES) AS Total_Sales
FROM YourTableName
GROUP BY REGION
ORDER BY REGION;

--


Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

[Back to original message]