-- write a query to find first and last name where employee's first name starts with j
create table employee(EmpID int, EmpFirstName varchar(255),EmpLastName varchar(255),Address varchar(255),salary int);
insert into employee(EmpID, EmpFirstName, EmpLastName, Address, Salary)
values(1,"John","Doe","Delhi",10000),
(2,"Collins","john","Chandigarh",20000),
(3,"Johny","Doey","Delhi",10000),
(4,"Collinsy","johny","Chandigarh",20000),
(5,"Harryy","Jonesy","Delhi",15000); 

select EmpFirstName, EmpLastName from employee where EmpFirstName like '%j%';
select EmpFirstName, EmpLastName,salary from employee where Address="Delhi";
---------------------------
-- select First(salary) from employee;
-- select Last(salary) from employee;
---------------------------
select avg(salary) from employee;
select count(salary) from employee;
select sum(salary) from employee;
select max(salary) from employee;
-- The MAX() function returns the largest value of the selected column.
select min(salary) from employee;
-- The MIN() function returns the smallest value of the selected column.