Getting Stratified data from MySQL -

i have 2 tables. teams , players. want create query tells me statistical data salary of largest team. want count of how many players make less 5k. how many make between 5k , 10k ....in increments of 5k max player.

here sql:

create  table `formsfiles`.`teams` (   `id` int not null auto_increment ,   `name` varchar(45) null ,   primary key (`id`) );   insert `teams` (`name`) values ('sharks'); insert `teams` (`name`) values ('jets'); insert `teams` (`name`) values ('fish'); insert `teams` (`name`) values ('dodgers');   create  table `players` (   `id` int not null auto_increment ,   `name` varchar(45) null ,   `team_id` int null ,   `salary` int null ,   primary key (`id`) );  insert `players` (`name`, `team_id`, salary) values ('jim', '1', '4800'); insert `players` (`name`, `team_id`, salary) values ('tom', '1', '12000'); insert `players` (`name`, `team_id`, salary) values ('harry', '2', '1230'); insert `players` (`name`, `team_id`, salary) values ('dave', '2', '19870'); insert `players` (`name`, `team_id`, salary) values ('tim', '3', '1540'); insert `players` (`name`, `team_id`, salary) values ('trey', '4','7340'); insert `players` (`name`, `team_id`, salary) values ('jay', '4', '4800'); insert `players` (`name`, `team_id`, salary) values ('steve', '4','6610'); insert `players` (`name`, `team_id`, salary) values ('chris', '4','17754');  

given data: dodgers largest team (id =4) output of:

0-5000       1 5000-10000   2 10000-15000  0 15000-20000  1 

if code looks familiar because evolution of problem of prior problem posted here. kindly don't beat me down!

this code want

select 5000 * floor(salary / 5000), count(*) players  team_id = 4 group floor(salary / 5000) 

it returns low border of range , number of entries

0        1 5000     2 15000    1 

note not return empty ranges.