Company: Media_Net_Product_Analysis
Difficulty: medium
Job Offers 2.0 Problem Description You are given 3 tables namely 'Students', 'Departments' and 'Jobs'. Write an SQL query to find sum of Distinct salaries obtained by students from 'CSE' department. The output should be sorted by the Department names. Note: There might be students who have got multiple job offers. Table: Students Id: primary key Fields: * Id (INT) * Name (Varchar) * DepartmentId (INT) Table: Departments DepartmentId of this table and DepartmentId of Students table are identical. Fields: * DepartmentId (INT) * DepartmentName (Varchar) Table: Jobs Id of this table and Id of Students table are identical. Fields: * Id (INT) * Salary (INT) NOTE: The output should contain one column by the name 'Salary'. Examples Example 1: Output: Salary 9500