Below Are Four Situations in Which the DML Component of SQL

Below are four situations in which the DML component of SQL can be used to manipulate and/or extract data.Indicate on the line beside each situation the letter(s)of the SQL statement,command,or condition which will allow a user to manipulate and/or extract the requested data and information.An answer may be used more than once,but not all answers will be used.
A.SELECT
B.WHERE
C.ON
D.OR
E.COUNT AS
F.GROUP BY
G.ORDER BY
H.FROM
I.INNER JOIN
J.IN
________ 1.The query calls for selecting certain names and zip codes,sorted by zip code.
________ 2.The query calls for selecting certain companies found in the USA and Canada tables and grouping them by country
________ 3.The query calls for appending the company name for company 12 to the topics located in the notes table.
________ 4.The query calls for summarizing the count of companies by country.