730 views
0 votes
0 votes

Consider the query:

select course id, semester, year, sec id, avg (tot cred)
from takes natural join student
where year = 2009
group by course id, semester, year, sec id
having count (ID) >= 2;


Explain why joining section as well in the from clause would not change
the result.

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
2
ajaysoni1924 asked Mar 30, 2019
683 views
Rewrite the where clausewhere unique (select title from course)without using the unique construct.
0 votes
0 votes
0 answers
4