Material Visto en Clases Hoy

select * from empleado where upper(sexo)='M'
select * from empleado where lower(sexo)='m'
select count (*) from empleado where lower(sexo)='f'
select count (*) from empleado where cargo

select cargo, count(numempleado) as Cantidad
from empleado
group by cargo
having count(*) > 4
order by cargo desc

Cuantos Asistente Mujeres hay ?
select count (*) from empleado
where upper(sexo)='F' and upper(cargo)='ASISTENTE'


select count (*) from oficina
select * from oficina
select ciudad, count (*) as "Numero de Oficinas"
from oficina
group by Ciudad