MYSQL - Multiple count in rows instead of columns

[rogernem]

When I execute the sql query bellow:

SELECT (SELECT count(STATE) FROM `table` WHERE STATE='MI') as E1, (SELECT count(STATE) FROM `table` WHERE STATE='ID') as E2 FROM `table`

the result is something like this:
E1 E2
12 15
One next to the other.

How could I have the results one BELLOW the other ?!!
This is what I would like:
E1 12
E2 15

Any ideas?

[Shuja Ali]

You are actually looking for Group By. A group By would give you result like this

State Count
MI 12
ID 15

Try this query

Select STATE, Count(STATE) From  TABLE Group By STATE