SQL questions! Please help

[hwanydat]

Could someone please review and help on these questions?

1. pull columns A, B, C, D, E
2. search for X and Y from columns A - E
3. combine multiple tables (Table 1, 2, and 3)
4. and group the results however you see fit (column H)

My attempts are

1. SELECT A, B, C, D, E FROM (table name) ;
2. SELECT A, B, C, D, E FROM (table name)
   WHERE name = X AND Y ; -> I’m lost here
3. SELECT * FROM 1
   JOIN 2 AND 3 ON ;
4. SELECT * FROM 1
   JOIN 2 AND 3 ON
   GROUP BY H;

Thank you!

[mtf]

Please remember to include a link to the exercise when posting questions in the Q&A forums. Thanks.