Question

A secretaria Municipal de Transportes, recebeu da empresa de transportes coletivos uma planilha para o reajuste anual do preço das passagens, com essa planilha foi enviado um BKP com uma tabela chamada GIROCATRACA do ultimo Mês, esta tabela conta com a seguinte estrutura: campos id int(6) primary key Not Null, TP_catraca int(2) not null, produto int(2) not null. onde o campo TP_Catraca recebe os valores 1 para catraca em Terminais urbanos e 2 para catracas em Onibus/Microonibus/Vans. Para determinar a validade do reajuste para o cargo de Cobrador, a Secretaria solicitou a T.I. a contagem dos giros de catraca TOTAL, Catracas de Veículos e Catracas de Terminais urbanos. Ao que a equipe desenvolveu 1 único script que retornou as seguintes informações.



Total_Ctr_Veic Total_Ctr_Terminal Total_Giros


Análise as alternativas a seguir, identificando a que representa o correto Script.

Assinale a alternativa que correta.

Escolha uma:

a. SELECT
(SELECT SUM (tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 2) AS CATRACA_CARRO,
(SELECT SUM (tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 1) AS CATRACA_TERMINAL,
(SELECT SUM (*) FROM GIROCATRACA) AS TOTAL_MES
FROM GIROCATRACA ORDER BY TOTAL_GIROS;

b. SELECT
(SELECT COUNT(tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 2) AS TOTAL_CTR_VEIC,
(SELECT COUNT(tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 1) AS TOTAL_CTR_TERMINAL,
(SELECT COUNT(*) FROM GIROCATRACA) AS TOTAL_GIROS
FROM GIROCATRACA GROUP BY TOTAL_GIROS;

c. SELECT
(SELECT tp_catraca FROM GIROCATRACA WHERE tp_catraca = 1) AS TOTAL_CTR_VEIC,
(SELECT tp_catraca FROM GIROCATRACA WHERE tp_catraca = 2) AS TOTAL_CTR_TERMINAL,
(SELECT * FROM GIROCATRACA) AS TOTAL_GIROS
FROM GIROCATRACA GROUP BY tp_catraca;

d. SELECT
(SELECT COUNT(tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 1) AS TOTAL_CTR_VEIC,
(SELECT COUNT(tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 2) AS TOTAL_CTR_TERMINAL,
(SELECT COUNT(*) FROM GIROCATRACA) AS TOTAL_GIROS
FROM GIROCATRACA GROUP BY TOTAL_GIROS;

e. SELECT
(SELECT DISTINCT (tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 2) AS TOTAL_CTR_VEIC,
(SELECT DISTINCT (tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 1) AS TOTAL_CTR_TERMINAL,
(SELECT DISTINCT (*) FROM GIROCATRACA) AS TOTAL_GIROS
FROM GIROCATRACA;

Answer 1

A resposta correta é:

SELECT

(SELECT COUNT(tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 2) AS TOTAL_CTR_VEIC,

(SELECT COUNT(tp_catraca) FROM GIROCATRACA WHERE tp_catraca = 1) AS TOTAL_CTR_TERMINAL,

(SELECT COUNT(*) FROM GIROCATRACA) AS TOTAL_GIROS

FROM GIROCATRACA GROUP BY TOTAL_GIROS;

Answer 2

Resposta:AV 2.

1 - E

2 - C

3 - C

4 - E

5 - B

Explicação:

CORRIGIDO POR COLABKRAR AVA.