1. Write a correlated subquery to determine whether the data support the supposition to the following.
Suppose that a table contains two nonkey columns; AdviserName and AdviserPhone. Further suppose that you suspect that AdviserPhone → AdviserName.
2. Answer question 1 but use EXISTS.© BrainMass Inc. brainmass.com October 9, 2019, 9:47 pm ad1c9bdddf
A correlated subquery is written to determine whether the data support required the supposition. Also an equivalent sql statement is provided using EXISTS (see attachment).