select fname , lname , instr(email,'@')-1 as 'broj bajtova' from employee where email is not null ; select fname , lname , salary , bonus , state from employee where right(lname,1) =right(fname,1); select sum(salary)+sum(bonus) from employee where salary>6000 and bonus<500; select count(*) from employee where bonus is null and email like'%@gmail.com'; select fname , lname , salary , bonus , state from employee where salary>(select avg(salary) from employee where state in('oh','tx','fl')) order by salary asc; select sum(case when gender='f' then salary end) as 'ukupno zene' , sum(case when gender='m' then salary end) as 'ukupno muskarci' , sum(salary) as 'ukupno' from employee; select count(*) from employee where bdate>(select max(bdate)from employee where state = 'fl'); select count(*) from employee where salary>((select max(salary) from employee where state = 'ca')+ (select min(salary)from employee where state = 'ca' ))/2; select fname , lname , bdate , salary , bonus from employee where gender='m' and salary>(select max(salary) from employee where gender = 'f');