Hi I used the table below in writng this query SELECT Student,COUNT(Score)>=10 AS NumberOfPasses WHERE Credit>2 GROUP BY Student |
Student | Credit | Score |
Tomy | 3 | 11 |
Tomy | 3 | 8 |
Tomy | 2 | 13 |
Tomy | 3 | 14 |
Dick | 3 | 8 |
Dick | 3 | 14 |
Dick | 2 | 12 |
Dick | 3 | 7 |
Hary | 3 | 8 |
Hary | 3 | 7 |
Hary | 2 | 11 |
Hary | 3 |
The result I need is
Student | NumberOfPasses |
Tomy | 2 |
Dick | 1 |
Hary | 0 |
But Im not getting it. Error occurs.
Can someone help
Thanks