Now that you are familiar with both subquery and join. Write few short paragraphs that answer the following questions:

1. How is join different from subquery? How are they similar?

2. From a performance perspective, which one performs better? Why?

3. Can join and subquery be used together in the same SQL query? If so, give an example.