Below Are Four Situations in Which the DML Component of SQL

question 119

Short Answer

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.

---

Definitions:

Disinflation

The process of slowing down the rate of inflation, resulting in a decrease in the general price levels of goods and services over time.

Inflation

The frequency at which the overall pricing of goods and services heightens, eroding the ability to buy.

Price Level

A measure indicating the average price of goods and services in an economy, often compared over time to assess inflation or deflation.

Inflation

The rate at which the cost of goods and services goes up, thereby reducing the purchasing capacity.