Group by two columns and count

[bas85]

I am trying to do this:

SELECT DISTINCT COMBINED.[Class], COMBINED.[Class Scheme], COUNT(*)
FROM COMBINED
WHERE (((cost])="0"));

but it does not work.

I would like to groupy by the first two columns and count them but it does not work and I am having trouble. Please any help would be great!!!

I am trying to do exactly this in Access. This is the example I am trying to follow:

SELECT species, sex, COUNT(*) FROM Bird GROUP BY species, sex;


+---------+------+----------+
| species | sex | COUNT(*) |
+---------+------+----------+
| Bus | m | 2 |
| Car | f | 1 |
+---------+------+----------+
2 rows in set (0.02 sec)

[pbaldy]

You left out the GROUP BY clause from the example. It would go after the WHERE clause.

[bas85]

Sorry this is the query I am running and it still doesn't work.

SELECT DISTINCT COMBINED.[Class], COMBINED.[Class Scheme], Count(*)
FROM COMBINED
GROUP BY COMBINED.[Construction Class], COMBINED.[Construction Class Scheme]
HAVING ((((COMBINED.[Cost]))="0"));

[bas85]

SELECT DISTINCT COMBINED.[Class], COMBINED.[Class Scheme], Count(*)
FROM COMBINED
GROUP BY COMBINED.[Class], COMBINED.[Class Scheme]
HAVING ((((COMBINED.[Cost]))="0"));

[bas85]

I got it to work!!

SELECT DISTINCT COMBINED.[Class], COMBINED.[Class Scheme], Count(COMBINED.[Cost]) AS [CountOfCost]
FROM COMBINED
Where ((((COMBINED.[Cost]))="0"))
GROUP BY COMBINED.[Class], COMBINED.[Class Scheme];

[pbaldy]

Good job, and welcome to the site by the way!