how to fetch the data using nested queries or sub queries using operators. code example
Example: NESTED QUERY SQL
SELECT column_name [, column_name ]
FROM table1 [, table2 ]
WHERE column_name OPERATOR
(SELECT column_name [, column_name ]
FROM table1 [, table2 ]
[WHERE])