(Solved):   Draw canonical and optimized query trees for the following \( \mathrm{SQL} \) query. selec ...

 

Draw canonical and optimized query trees for the following \( \mathrm{SQL} \) query. select c.customer_name, c.customer_city, l.amount from customer \( c \), borrower \( b \), loan 1 where c. customer_name \( =b \).customer_name and b. loan_number \( =1 \). loan_number and 1. branch_name = 'Perryridge' and l.amount > 1000;