Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q.No.5. Write the SQL queries of following questions: Write a query to display all departments no, which have more-than 2 instructors without using Join or

Q.No.5.

Write the SQL queries of following questions:

  1. Write a query to display all departments no, which have more-than 2 instructors without using Join or Sub Queries.
  2. Write a query to display instructors who have taught course which course id starts except "CS-4".
  3. Write a query using Joins to display 2nd lowest salary of instructor using Join.
  4. Write a query using Joins to display first name, age and department name of youngest instructor's from each department. Using Join

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MFDBS 91 3rd Symposium On Mathematical Fundamentals Of Database And Knowledge Base Systems Rostock Germany May 6 9 1991

Authors: Bernhard Thalheim ,Janos Demetrovics ,Hans-Detlef Gerhardt

1991st Edition

3540540091, 978-3540540090

More Books

Students also viewed these Databases questions

Question

2. Describe why we form relationships

Answered: 1 week ago

Question

5. Outline the predictable stages of most relationships

Answered: 1 week ago