The following two queries are about the average salary (avg(salary) ) from the "Instructor" table:
avg(salary) from Instructor;
select sum(salary) /count(salary) from Instructor;
Which of the following is correct?
a) Both queries will give the same result.
b) The first query calculates the average salary for all instructors.
c) The second query calculates the average salary for all instructors.
d) The first query calculates the sum of all salaries divided by the total count of instructors.