SQL Server: Obtain the left outer join between the student (left) and the Dept (right) table such that you get to see all students with their course requirements. Note that not all students have course.

Customer Table Customer ID 345 564 356 765 786 Customer Name John Spence Dave Marks Bob Orton Kevin Cart Joe Dole Ordernum 34 56 45 78 98 Order Table OrderID 98 98 34 34 56 Products Shampoo Chocolate Carrot Milk Orange Student Table Student ID 345 332 356 567 Dept Name MATH ME ECE CS Dept Table Dept Name MATH MATH CS CS Course MATH 2010 MATH 3506 COMP 5400 COMP 3010