Which type of join is this SELECT statement?

SELECT first_name, last_name, balance

FROM checking_accounts ca JOIN customers c ON (ca.customer_id = c.customer_id);

Which type of join is this SELECT statement?

SELECT first_name, last_name, balance

FROM checking_accounts ca JOIN customers c ON (ca.customer_id = c.customer_id);

natural join

outer join

self join

cross join

inner join

Which of the following is the correct order of listing clauses in a SELECT statement?

Which of the following is the correct order of listing clauses in a SELECT statement?

SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

SELECT, FROM, ORDER BY, WHERE, GROUP BY, HAVING

SELECT, FROM, GROUP BY, HAVING, WHERE, ORDER BY

Which of the following meets the specification of '%Cherry_Pie_'?

Which of the following meets the specification of '%Cherry_Pie_'?

1 box of Cherry Pie!

Cherry_Pie

Apple and Cherry Pie

Cherry Pie and Cake