SQL questions! Please help


#1

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!


#2

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


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.