Question 1 Correct Marked out of 1 Flag question Question text The employee table contains EmployeeNumber, EmployeeName, Salary and DeptCode Columns. Which is the CORRECT SQL query to display DeptCode and average salary of each department? Choose most appropriate option. Select one: a. SELECT DeptCode,avg(salary) FROM Employee GROUP BY DeptCode; b. SELECT DeptCode,avg(salary) FROM Employee GROUP BY EmployeeNumber; c. SELECT DeptCode,avg(salary) FROM Employee; d. SELECT DeptCode,avg(salary) FROM Employee GROUP BY Salary; Feedback The correct answer is: SELECT DeptCode,avg(salary) FROM Employee GROUP BY DeptCode; Question 2 Correct Marked out of 1 Flag question Question text Which is the CORRECT SQL Query to display names of employees which has only 3 letters that starts with 'A' and ends with 'e'? Choose most appropriate option. Select one: a. SELECT EmployeeName FROM Employee WHERE EmployeeName LIKE 'A_e'; b. SELECT Em...
We provides solutions for different resources over internet.



Comments
Post a Comment