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 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 here.