Questões de Concurso Público LIQUIGÁS 2018 para Profissional Júnior - Analista de Sistemas

SELECT F.NOME

FROM FILME F, GRADE G

WHERE F.CODIGO=G.COD_FILME

GROUP BY F.NOME

HAVING COUNT(F.NOME)=0

SELECT NOME

FROM FILME

MINUS

SELECT F.NOME

FROM FILME F, GRADE G

WHERE F.CODIGO=G.COD_FILME

SELECT DISTINCT F.NOME

FROM FILME F

LEFT JOIN GRADE G ON F.CODIGO=G.COD_FILME

WHERE G.DIA=NULL AND HORA=NULL

SELECT F.NOME

FROM FILME F, GRADE G

WHERE F.CODIGO=G.COD_FILME

INTERSECT

SELECT NOME

FROM FILME

SELECT F.NOME

FROM FILME F, GRADE G

WHERE F.CODIGO=G.COD_FILME

MINUS

SELECT NOME

FROM FILME

SELEC0T C.NOME, COUNT(*)

FROM CANAL C, GRADE G

WHERE C.NUMERO=G.NUM_CH

ORDER BY COUNT(*)

SELECT C.NOME, COUNT(*) AS X

FROM CANAL C, GRADE G

WHERE C.NUMERO=G.NUM_CH

GROUP BY C.NOME

ORDER BY COUNT(*)

SELECT C.NOME, COUNT(*) AS X

FROM CANAL C, GRADE G

WHERE C.NUMERO=G.NUM_CH

ORDER BY X

SELECT C.NOME, COUNT(*) AS X

FROM CANAL C, GRADE G

WHERE C.NUMERO=G.NUM_CH

GROUP BY C.NUMERO

ORDER BY X

SELECT C.NOME, COUNT(*) AS X

FROM CANAL C, GRADE G

WHERE C.NUMERO=G.NUM_CH

ORDER BY COUNT(X)

GROUP BY C.NOME