Prueba SQL para Analista de CRM [IMCRUZ]

Create an image depicting a person sitting at a computer analyzing data with SQL code on the screen, surrounded by CRM graphs and charts.

SQL Skills Assessment for CRM Analysts

Put your SQL knowledge to the test with our engaging quiz designed specifically for CRM Analysts! Discover how well you understand SQL queries, procedures, and functions.

Covering essential SQL concepts
Multiple choice questions for easy comprehension
Evaluate your skills and identify areas for improvement

9 Questions2 MinutesCreated by QueryMaster245

Seleccione la query que regrese todos los departamentos en la tabla (sin duplicados)

SALARIES (
Professor_Name (TEXT),
Department (TEXT),
Salary (INT)
)

SELECT ALL Department FROM Salary;

SELECT DISTINCT Department FROM SALARIES;

SELECT DISTINCT Professor_Name FROM *;

SELECT FROM Department

Seleccione la query que regrese el nombre y salario de el profesor con el salario mas alto.

SALARIES (
Professor_Name (TEXT),
Department (TEXT),
Salary (INT)
)

SELECT Professor_Name, MAX(Salary) FROM Department;

SELECT Professor_Name, MAX(Salary) FROM SALARIES;

SELECT MIN(Salary),Professor_Name, FROM Department;

Ninguna de las anteriores

Seleccione la query que regrese todos los nombres de profesores que inicien con la letra "C".

SALARIES (
Professor_Name (TEXT),
Department (TEXT),
Salary (INT)
)

SELECT Professor_Name FROM SALARIES WHERE Professor_Name LIKE 'C%';

SELECT Professor_Name FROM SALARIES FROM Professor_Name LIKE 'C';

SELECT Professor_Name FROM SALARIES WHERE Professor_Name LIKE Salary;

SELECT Professor_Name WHERE SALARIES FROM Professor_Name LIKE 'C%';

Seleccione la query que regrese el departamento con el salario promedio más alto junto con ese salario promedio.

SALARIES (
Professor_Name (TEXT),
Department (TEXT),
Salary (INT)
)

SELECT Department, AVG(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY AVG(Salary);

SELECT Department, AVG(Salary) FROM SALARIES ORDER BY AVG(Salary) DESC LIMIT 1;

SELECT Department, AVG(Salary) FROM SALARIES GROUP BY AVG(Salary) DESC LIMIT 1;

SELECT Department, AVG(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY AVG(Salary) DESC LIMIT 1;

Sentencia para eliminar un Procedimiento Almacenado:

DELETE nombre_procedimiento

Verdadero

Falso

Prueba SQL para Analista de CRM [IMCRUZ]

SQL Skills Assessment for CRM Analysts

More Quizzes