--EXERCICIO 46
--select F.CODCAT AS CODIGO_CATEGORIA, C.DESCRICAO, COUNT(*) AS SOMA_DE_FILMES
--from FILME F INNER JOIN CATEGORIA  C
--ON F.CODCAT = C.CODCATEG
--GROUP BY F.CODCAT, C.DESCRICAO
--------------------------------------------------------------------------------

--EXERCICIO 47

--SELECT P.PRENOME, COUNT(*)
--FROM LOCACAO L INNER JOIN CLIENTE P
--ON L.CODCLI = P.CODCLI
--GROUP BY P.PRENOME
--------------------------------------------------------------------------------

--EXERCICIO 48

--SELECT E.ENAME AS NOME,E.HIREDATE, E.SAL AS SALARIO, D.DEPTNO AS DEPARTAMENTO
--FROM EMP E INNER JOIN DEPT D
--ON D.DEPTNO = E.DEPTNO
--WHERE E.HIREDATE LIKE '%81%'
--------------------------------------------------------------------------------

--EXERCICIO 49

--SELECT MIN (SAL), MAX (SAL), ROUND (AVG(SAL),2) AS MEDIA, DEPT.DNAME
--FROM EMP INNER JOIN DEPT
--ON EMP.DEPTNO = DEPT.DEPTNO
--GROUP BY DEPT.DNAME
--------------------------------------------------------------------------------

-- EXERCICIO 50

--SELECT E.ENAME, E.SAL, D.DEPTNO, D.DNAME, E.HIREDATE
--FROM EMP E INNER JOIN DEPT D
--ON E.DEPTNO = D.DEPTNO
--WHERE E.HIREDATE LIKE '%87%'
--------------------------------------------------------------------------------

-- EXERCICIO 51

--SELECT E.ENAME,E.JOB, D.DEPTNO, E.SAL, D.DNAME
--FROM EMP E INNER JOIN DEPT D
--ON E.DEPTNO = D.DEPTNO
--ORDER BY E.JOB, E.ENAME
--------------------------------------------------------------------------------

--EXERCICIO 52

--SELECT D.DNAME, COUNT(*)
--FROM EMP E INNER JOIN DEPT D
--ON E.DEPTNO = D.DEPTNO
--GROUP BY D.DNAME
--------------------------------------------------------------------------------

--EXERCICIO 53

--SELECT SUM (E.SAL), D.DNAME
--FROM EMP E INNER JOIN DEPT D
--ON E.DEPTNO = D.DEPTNO
--GROUP BY D.DNAME
--------------------------------------------------------------------------------

--EXERCICIO 57

--SELECT  DTMATRIC, IDALUNO AS COD_ALUNO, NOME AS NOME_DO_ALUNO, DTNASC AS DATA_NASC
--FROM ALUNO
--WHERE DTMATRIC
--BETWEEN '15/03/08' AND '30/04/08'
--------------------------------------------------------------------------------