create table club
(
coach_id varchar(20),
namec    char(20),
age      int,
sports   varchar(20),
DOB      date,
fees     int,
gender   char(1),
city     varchar(30),
bonus    int

);
describe club;
insert into club values ('c00','ram',40,"cricket",'1988-01-10',8778,'m','delhi',1500);
insert into club values ('co1','kukreja',38,"karate",'1996-03-27',33338,'m','delhi',1500);
insert into club values ('c02','RAVINA',34,"cricket",'1996-01-20',4643,'f','mumbai',1000);
insert into club values ('c03','karan',34,"squash",'1998-02-24',3525,'m','delhi',2000);
insert into club values ('c04','tarun',40,"karate",NULL,4832,'M','mumbai',2068);
insert into club values ('c05','zubin',36,"basketball",'1990-01-12',4468,'m',NULL,NULL);
insert into club values ('c06','ketaki',36,"cricket",NULL,NULL,'f','kolkatta',NULL);
insert into club values ('c07','ankita',39,"squash",'1998-02-24',NULL,'f','delhi',102);
insert into club values ('c08','zareen',47,"basketball",NULL,3523,'f','kolkatta',1053);
insert into club values ('c09','kanishk',41,"cricket",'198-01-13',NULL,'m',NULL,78);
insert intO club values ('c10','simran',30,"basketball",'2003-11-14',4248,'f','delhi',NULL);
SELECT * FROM club
select sports,max(fees),sum(fees),count(*) from club group by sports having count (*)>1;