Draw canonical and optimized query trees for the following SQL query. select c.customer_name, c.customer_city, 1.amount from...

 

Transcribed Image Text:

Draw canonical and optimized query trees for the following SQL query. select c.customer_name, c.customer_city, 1.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 1.amount > 1000; Draw canonical and optimized query trees for the following SQL query. select c.customer_name, c.customer_city, 1.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 1.amount > 1000;