clase 02/12 SQL

/*select * from empleado where LOwER (sexo) ='f'*/
/*desc empleado*/ /*select cargo, count(numempleado) as cantidad
from empleado
group by cargo
having count(*) >= 5
/*order by cargo desc*/select
count (*) from empleado where upper(cargo) = 'ASISTENTE' and lower(sexo) ='f' desc oficinaselect
ciudad, count (*) from oficinagroup by ciudad