The six clauses of the SELECT statement must be coded in the following order: O A SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING OB. SELECT, FROM, ORDER BY, WHERE, GROUP BY, HAVING OC. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY OD. SELECT, FROM, GROUP BY, HAVING, WHERE, ORDER BY Question 7 In a join, column names need to be qualified only OA in inner joins OB. when the same names are used in both tables OC when the code is confusing OD. in outer joins k