SQL output the number of identical values?

Question

SQL

There is a table
Ban| banana| login
12| 12| master
1 | 5 |master
2| 3| kiril
6|8|maksim
5|3| MASTER
how to output for example the number of master in the code?

Answer 1

SELECT COUNT(*) FROM `table_name` WHERE `login`='master'

here is an example on my table:

Answer 2

select login, count(*) cnt from таблица group by login having cnt > 1 order by cnt desc