query group by over another group by?

[gap]

Hello,
I am new to access sql and got a problem with a query:

I got a table like:



theme subtopic

a fish
a fish
a vegetables
b vegetables
c fruits
c fruits
c fish

now i want to get the number of subtopics for each theme.
anyone got an idea how to solve in a query?

thanx a lot,
gap

[ajetrumpet]

select theme, count([subtopic]) as [Number of Subtopics]

from table

group by theme

[gap]

thank you, but it was a bit more complex. I wanted to count number of different subtopics for each theme. So instead of getting 3 subtopics for theme a, I have to get 2.

so here my solution for this one:

SELECT theme, Count(subtopic) AS NumofSubtopic
FROM
(SELECT DINSTINCT theme, subtopic
FROM my_own_table)
GROUP BY theme;