logo

Crowdly

Browser

Add to Chrome

CS 231-G2 - Introduction to databases - Spring 2025

Looking for CS 231-G2 - Introduction to databases - Spring 2025 test answers and solutions? Browse our comprehensive collection of verified answers for CS 231-G2 - Introduction to databases - Spring 2025 at lms.musteducation.tn.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

What is the purpose of this query?

SELECT Name,  

  CASE  

    WHEN Salary > 10000 THEN 'High'  

    WHEN Salary BETWEEN 5000 AND 10000 THEN 'Medium'  

    ELSE 'Low'  

  END AS SalaryLevel  

FROM Employees;

❌
✅
❌
❌
View this question

What does this query output?

SELECT Department, COUNT(*)  

FROM Employees  

GROUP BY Department  

WITH ROLLUP;

❌
❌
✅
❌
View this question

Which query returns names of employees who work in the same department as 'Alice'?

✅
❌
❌
❌
View this question

What does this query return?

SELECT Department, AVG(Salary)  

FROM Employees  

GROUP BY Department  

ORDER BY AVG(Salary) DESC;

❌
❌
❌
✅
View this question

Which of the following queries returns the second highest salary?

0%
0%
0%
0%
View this question

What will this query do?

SELECT Name  

FROM Employees  

WHERE ManagerID IS NULL;

❌
❌
❌
✅
View this question

What is the role of the alias e in the following query?

SELECT e.Name FROM Employees e WHERE e.Department = 'IT';

❌
✅
❌
❌
View this question

Which query returns employees who earn more than the average salary?

0%
0%
0%
0%
View this question

1. What does this query return?

SELECT Department, COUNT(*)  

FROM Employees  

GROUP BY Department  

HAVING COUNT(*) > 5;

0%
0%
0%
0%
View this question
Retrieve the current salary of an employee

Which SQL query retrieves the current salary of an employee with emp_no = 20005?

❌
❌
✅
❌
View this question

Want instant access to all verified answers on lms.musteducation.tn?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome