EXAMPLE 

This would make a nice example of how to create a more complex query
https://wordpress.stackexchange.com/questions/307511/get-terms-of-posts-with-category-with-sql

Should be included in the wiki and have it's on dir tests to showcase it. Obviously, this will need a lot of mock data to play with