Nested Query 4 in SQL

For Complete YouTube Video: Click Here

In this class, we will try to understand SQL Query on Multiple Tables.

We have already discussed the concepts of Cartesian Product in SQL.

Nested Queries in SQL

A clear understanding of the query is made in the above youtube link.

The queries and the outputs of the queries are as shown below.

Query 1: