Question: Write the SQL queries of the following questions: i. Write a query to display all departments no, which have more-than 2 instructors without using Join
Write the SQL queries of the following questions:
i. Write a query to display all departments no, which have more-than 2 instructors without using Join or Sub Queries.
ii. Write a query to display instructors who have taught courses in which course id starts except "CS-4".
iii. Write a query using Joins to display the 2nd lowest salary of the instructor using Join.
iv. Write a query using Joins to display the first name, age and department name of the youngest instructor's from each department. Using Join
Note: its just a paper question no database schema is build so you can answer just basic queries, not for specific database schema
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
