For this research request, a couple of sub-queries were used. Think about which tables we will be pulling data from. Can you come up with your own list? Here are the **[[Practice7tables tables]]** this example uses.

It's helpful to think about how you take each of the fields requested, then group them by tables, and build a query off of it. After building these discrete queries, you will be able to JOIN all their data together, for your final query consisting of these sub-queries.

The sub-queries used for building this request are listed **[[Practice7Subqueries here]]**.