Added yaml test for in join in
Added a simpler yaml case for in-join-in bug

I guess this is no longer in join in, so I should probably rename
the file
Split up yaml test
Updated comment based on observed reality
Added two more tests that I think I could break
switched column reference in test

all of the artist_id's are empty.

This bug might be unrelated, but it is a bug. If I end up fixing it,
great, otherwise, I'll file a new issue.
Fixed yaml test syntax
Move all conditions down to inner most inner join

This should be breaking things, but I don't know what yet.
Added test to catch if condition moved too far

You can't move conditions to where the table sources aren't referenced
so, don't
First pass at not moving conditions

this is terribly inneficient, but first I want it working and
tested
More correcly move conditions down

still causes tests to break
Only move where conditions to root inner join
Change lexicographical order of tables in query
move where conditions to inner join for IN *

Instead of moving WHERE clauses up into the SEMI/ANTI join, if
there's an INNER JOIN in the right side, move them down to the
inner join. This kind of undoes the effect of the GroupJoinFinder
Fixed typo in yaml test
Updated comment
Updated expected output
Added RulesTest for NOT IN JOIN IN
Commented out assertions for yaml test

this test is unrelated to the current issue, and is failing, I
added a card for the issue for the test
Added new test for other issue that I'm fixing

No code change was required for this to work, but I figured I
should add the yaml test just in case