isolate each part of the statement, and perform the same operation that would ordinarily require
Answer and provide 1 reference. Advanced SQL and PL/SQL Respond to this discussion Response: Sub queries are important and advantageous because they are structured in such a way that they…