Query help?

[chrisb]

SELECT Count(Sno) AS Total, Bno
FROM Staff
WHERE Count >3
GROUP BY Bno;

Seems to ignore the > 3 line and display all records. Can anyone see why?

Thanks

[chazzy]

what is in the column count?

do you maybe mean

SELECT Count(Sno) AS Total, Bno
FROM Staff
WHERE Total >3
GROUP BY Bno;