SQL Query Quiz

¿Qué consulta muestra el número de empleados por departamento?

• SELECT department_id, COUNT(*) FROM employees GROUP BY department_id;

• SELECT COUNT(*) FROM employees GROUP BY department_id;

• SELECT department_id, SUM(*) FROM employees;

• SELECT department_id, COUNT(*) FROM employees WHERE GROUP BY department_id;

¿Para calcular las ventas totales de 2023 en la tabla de pedidos, cuál es la consulta correcta?

• SELECT SUM(total) FROM orders WHERE year = 2023;

• SELECT SUM(total) FROM orders GROUP BY year = 2023;

• SELECT SUM(total) FROM orders HAVING year = 2023;

• SELECT TOTAL() FROM orders WHERE year = 2023;

¿Qué consulta devuelve el salario promedio del departamento con department_id = 5?

• SELECT AVG(salary) FROM employees WHERE department_id = 5;

• SELECT AVG(salary) FROM employees GROUP BY department_id = 5;

• SELECT department_id, AVG(salary) FROM employees GROUP BY department_id HAVING department_id = 5;

• SELECT AVG(salary) FROM employees HAVING department_id = 5;

¿Qué cláusula se utiliza para filtrar resultados después de aplicar GROUP BY?

• WHERE

• HAVING

• GROUP BY

• ORDER BY

¿Qué consulta cuenta los pedidos del cliente con customer_id = 100 realizados después del 1 de enero de 2023?

• SELECT COUNT(*) FROM orders WHERE customer_id = 100 AND order_date > '2023-01-01';

• SELECT COUNT(*) FROM orders GROUP BY customer_id = 100 HAVING order_date > '2023-01-01';

• SELECT customer_id, COUNT(*) FROM orders WHERE order_date > '2023-01-01';

• SELECT COUNT(*) FROM orders WHERE customer_id = 100 GROUP BY order_date > '2023-01-01';

¿Qué consulta muestra el salario más alto por departamento?

• SELECT department_id, MAX(salary) FROM employees GROUP BY department_id;

• SELECT department_id, TOP(salary) FROM employees GROUP BY department_id;

• SELECT department_id, salary FROM employees WHERE salary = MAX(salary);

• SELECT MAX(salary) FROM employees GROUP BY department_id;

¿Qué consulta es válida para mostrar el número de productos y el precio promedio por categoría?

• SELECT category, COUNT(product_id), AVG(price) FROM products GROUP BY category;

• SELECT COUNT(product_id), AVG(price) FROM products GROUP BY category;

• SELECT category, COUNT(*), AVG(price) FROM products;

• SELECT category, COUNT(*), AVG(price) FROM products GROUP BY category;

Seleccione la consulta que muestra productos con ventas totales superiores a $1000, excluyendo pedidos cancelados (estado = 'C'):

• SELECT product_id, SUM(amount) FROM orders WHERE status != 'C' GROUP BY product_id HAVING SUM(amount) > 1000;

• SELECT product_id, SUM(amount) FROM orders GROUP BY product_id WHERE SUM(amount) > 1000 AND status != 'C';

• SELECT product_id, SUM(amount) FROM orders HAVING SUM(amount) > 1000 AND status != 'C';

• SELECT product_id, SUM(amount) FROM orders WHERE SUM(amount) > 1000 GROUP BY product_id;

¿Qué consulta muestra el número de pedidos por mes en 2023, ordenados por mes?

• SELECT MONTH(order_date), COUNT(*) FROM orders WHERE YEAR(order_date) = 2023 ORDER BY MONTH(order_date);

• SELECT MONTH(order_date), COUNT(*) FROM orders GROUP BY MONTH(order_date) WHERE YEAR(order_date) = 2023;

• SELECT MONTH(order_date), COUNT(*) FROM orders WHERE YEAR(order_date) = 2023 GROUP BY MONTH(order_date) ORDER BY MONTH(order_date);

• SELECT MONTH(order_date), COUNT(*) FROM orders GROUP BY YEAR(order_date) = 2023;

¿Qué consulta calcula la cantidad total vendida por producto y año?

• SELECT product_id, YEAR(order_date), SUM(amount) FROM orders GROUP BY product_id, YEAR(order_date);

• SELECT product_id, SUM(amount) FROM orders GROUP BY product_id, YEAR(order_date);

• SELECT product_id, YEAR(order_date), SUM(amount) FROM orders GROUP BY product_id;

• SELECT product_id, YEAR(order_date), TOTAL(amount) FROM orders GROUP BY product_id, YEAR(order_date);