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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started