Job Offer

You are given 3 tables namely ‘Students’ , ‘Departments’ and ‘Jobs’.

Write an SQL query to find for each student their name and the date of the job offer. The output should be sorted by Department Names. Note that there might be students who did not receive a single offer, in such cases you should not include them in the output table.

Table: Students

Id:primary key

Table:Departments

DepartmentId of this table and DepartmentId of Students table are identical

Table: Jobs

Id of this table and Id of Students table are identical.

NOTE : The output should contain one column by the name ‘Offers’ which should contain StudentName and The Date of the offer seperated by a ’ , ‘ .

Example :

NOTE: You only need to implement the given function. Do not read input, instead use the arguments to the function. Do not print the output, instead return values as specified. Still have a question? Checkout Sample Codes for more details.