Crosstab Query

create table data
(
name varchar(50),
gender char(1)
);
insert into data values('sukrisno','M');
insert into data values('johny','M');
insert into data values('wardati','F');
select gender, count(name) from data group by gender;
select
sum(if(gender='M',1,0)) AS 'M',
sum(if(gender='F',1,0)) AS 'F'
from data

Modified Column Name in SQL server

EXEC sp_rename @objname= 'TableName.ColumnName', @newname = 'New ColumnName', @objtype = 'COLUMN'