http://support.microsoft.com/kb/2461206

select SUM(OrderQty) 'Quantity', convert(varchar,month(OrderDate))+'-'+convert(varchar,YEAR(OrderDate)) as 'Month year'

from table1

group by MONTH(OrderDate),YEAR(OrderDate)

having year(OrderDate) between '2008' and '2011'

good twister

To get third highest salary

select MAX(salary) from Employees where salary <(select MAX(salary) from Employees

where salary <(select MAX(salary) from Employees))

change table name as what you have given i have used testtable

select distinct a.district,c.male as male,b.female as female from testtable a

left join

(select district,count(gender) as female from testtable

group by district,gender

having gender='female'

)b

on b.district=a.district

left join

(select district,count(gender) as male from testtable

group by district,gender

having...

select distinct a.district,c.male as male,b.female as female from testtable a

left join

(select district,count(gender) as female from testtablec

group by district,gender

having gender='female'

)b

on b.district=a.district

left join

(select district,count(gender) as male from testtablec

group by district,gender

having...

Third option calucates wrong age