Question: In this practice you: - Access data from more than one table using equijoins and non-equijoins - Use OUTER joins to view data that generally
In this practice you: - Access data from more than one table using equijoins and non-equijoins - Use OUTER joins to view data that generally does not meet a join condition - Generate a Cartesian Product Tasks 1. Display the different courses offered by the departments in the school. 2. Display the courses offered in the Fall session. 3. Display the course details, the department that offers the courses and students who have enrolled for those courses. 4. Display the course details, the department that offers the courses and students who have enrolled for those courses for department 20. 5. Write a query to display the details of the exam grades obtained by students who have opted for the course with COURSE_ID in the range of 190 to 192 . 6. Retrieve the rows from the AD_EXAM_RESULTS table even if there are no matching records in the AD_COURSES table. 7. What output would be generated when the given statement is executed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
