Employees

use employees
select* from employee
select count(*)employee from employee
select sum(salary)salary from employee
select substring(empfirstname,1,3)empfirstname from employee where empfirstname like 'b%'
select substring(emplastname,4,3)emplastname from employee where emplastname like 'p%'
select distinct(emplastname)emplastname from employee
select empfirstname,dateofjoining from employee where empfirstname like 'r%'
select datepart(month,dateofbirth)from employee
select dateofbirth,dateofjoining,datediff(yy,dateofbirth,dateofjoining)from employee
select count(department),department from employee group by department
select count(department),department from employee group by department having count(department)>1
select empfirstname,salary from employee where salary between 6000 and 18000

select * from sys.objects where type='u'
select empfirstname, case
when gender='m' then 'male'
when gender='f' then 'female'
else 'N/A' end gender
from employee
select top 1* from employee order by dateofjoining
select top 1* from employee order by dateofjoining desc
select avg(salary)avgsalary from employee
select empfirstname,replace(empfirstname,'b',2)empfirstname from employee where empfirstname like 'b%'
select empid,empfirstname,upper(empfirstname)empfirstname from employee
select datename +' '+datepart(m,getdate())from employee