1) Assume that you have two tables named T1 and T2. Further assume that T1 and...

  

Transcribed Image Text:

1) Assume that you have two tables named T1 and T2. Further assume that T1 and T2 share a common column named C1. Write one query example for each of the three inner join types. (10 points) 2) What is a recursive join? (5 points) 3) In a SELECT query, what is the difference between a WHERE clause and a HAVING clause? (10 points) 4) What is a subquery? (5 points) 5) What are the key characteristics of a subquery? (10 points) 1) Assume that you have two tables named T1 and T2. Further assume that T1 and T2 share a common column named C1. Write one query example for each of the three inner join types. (10 points) 2) What is a recursive join? (5 points) 3) In a SELECT query, what is the difference between a WHERE clause and a HAVING clause? (10 points) 4) What is a subquery? (5 points) 5) What are the key characteristics of a subquery? (10 points)