Questão 722054

SELECT DISTINCT TIPO FROM VISITAS;

SELECT DATA, TIPO FROM VISITAS WHERE TIPO = 'individual' ORDER BY DATA;

SELECT * FROM VISITAS WHERE DATA < '2024-07-01';

SELECT AVG(NUM_VISITANTES) FROM VISITAS GROUP BY TIPO;

SELECT TIPO, COUNT(*) AS NUM_VISITAS FROM VISITAS WHERE DATA BETWEEN '2024-01-01' AND '2024-06-30' GROUP BY TIPO;