(Solved): complete in SQL erfank hackerrank.com 4. Professor Names and Salaries A university maintains data on ...
complete in SQL
erfank hackerrank.com 4. Professor Names and Salaries A university maintains data on professors and departments in two tables: PRORESSOR and DEPARTMENT Write a query to print the NAME and SALARY for each professor who satisfies the following two requirements • The professor does not work in the Arts and Humanities department . The professor's salary is greater than the smallest salary of any professor in the Arts and Humanities department The name must be printed before the salary, but row order does not matter. Schema DEPARTMENT Name Type Description ID Integer Adepartment in the inclusive range 11. 1000). This is a primary key NAME String A department name. This field contains between 1 and 100 characters. PROFESSOR Name Type Description 10 Integer A professors ID in the inclusive range 1000 This is a primary key NAME String A professor's name. This field contains between and 100 characters DEPARTMENT ID Integer professors department. This is a foreign key to DEPARTMENTIO SALARY Integer A professor's salary in the indusive range 15000, 40000 Sample Data Tables DEPARTMENT NAME Biological Sciences 5 Technology 5 Humanities & Social Sciences 2 Clinical Medicine Arts and Humanities Type here to search o 1 W 1