Questão Q2788150 - Tecnologia da Informação

Question

Utilizando as linguagens de consulta de dados (DQL), analise a tabela FILM criada dentro do banco de dados MySQL abaixo e assinale a alternativa que tenha o código em SQL que responda à pergunta: Qual a quantidade de filmes que começam com a letra “A”? Utilize a coluna TITLE para filtrar o filme.

film_id	title	description	release_year
1	ACADEMY DINOSAUR	A Epic Drama of a Feminist And a Mad Scientist ...	2006
2	ACE GOLDFINGER	A Astounding Epistle of a Database Admintrat...	2006
3	ADAPTATION HOLES	A Astounding Reflection of a Lumberjack And a ...	2006
4	AFFAIR PREJUDICE	A Fanciful Documentary of a Frisbee And a Lum...	2006
5	AFRICAN EGG	A Fast-Paced Documentary of a Pastry Chef An...	2006
6	AGENT TRUMAN	A Intrepid Panorama of a Robot And a Boy who...	2006
7	AIRPLANE SIERRA	A Touching Saga of a Hunter And a Butler who ...	2006
8	AIRPORT POLLOCK	A Epic Tale of a Moose And a Girl who must Con...	2006
9	ALABAMA DEVIL	A Thoughtful Panorama of a Database Administ...	2006
10	ALADDIN CALENDAR	A Action-Packed Tale of a Man And a Lumberjac...	2006

Gran Questões · Accepted Answer

SELECT COUNT(FILM_ID) AS QTD_FILME FROM FILM WHERE TITLE LIKE 'A%'

Gran Questões · Answer

SELECT COUNT(FILM_ID) AS QTD_FILME FROM FILM WHERE TITLE LIKE '%A%'

Gran Questões · Answer

SELECT COUNT(*) AS QTD_FILME FROM FILM WHERE TITLE LIKE '%A'

Gran Questões · Answer

SELECT COUNT(DISTINCT TITLE) AS QTD_FILME FROM FILM WHERE TITLE = 'A'

Gran Questões · Answer

SELECT * FROM FILM WHERE DESCRIPTION = 'A%'

Utilizando as linguagens de consulta de dados (DQL)...