hELLO THERE
When I run: SELECT DISTINCT groupLetter
FROM well_tbl
I get:
|groupLetter |
|group A |
|group B |
When I run: SELECT COUNT() FROM well_tbl
I get:
|COUNT()|
|78 |
I will like to count all records pertaining to their respective groupLetters, so I ran:
SELECT COUNT(*) FROM well_tbl
WHERE groupLetter
= “(SELECT DISTINCT groupLetter
FROM well_tbl
)”
and I got:
|COUNT(*)|
|78 |
What am I missing?
I am using PHP/MySQL