NOT IN: https://www.sqlteaching.com/#!in
SELECT * FROM friends_of_pickles WHERE pieces NOT IN ('cat', 'dog');
INNER JOIN: https://www.sqlteaching.com/#!joins
SELECT x.column1, y.column2 FROM x INNER JOIN y on shared_column;
LEFT JOIN: https://www.sqlteaching.com/#!left_joins
SELECT x.column1,y.column1 FROM x LEFT JOIN z ON x.column2=z.column2 LEFT JOIN y ON z. column3=y.column2;