Pull Orders Processed to Individual where Household Exists

Hello all, 

We are about to launch our digital season and it has come to our attention that in order for patrons to view the productions, the order must be processed on the household level if one exists. I'm trying to figure out a way to pull all orders in this season that were processed to an individual where a household exists. Then, we would transfer the orders to the household.

I imagine a query would be possible, however, I'm still a SQL beginner. 

Unfortunately, time is of the essence. Any help would be appreciated! 

Thanks in advance, 

Michelle