The Correct SQL Syntax to Sort a Table by Last_Name

question 22

Multiple Choice

The correct SQL syntax to sort a table by Last_Name in order of A-Z is ______.

• A) SORT BY Last_Name ASCENDING
• B) ORDER BY Last_Name Down
• C) ORDER BY Last_Name ASC
• D) ORDER BY Last_Name DESC

---

Definitions:

Relative Frequency

The proportion of times a particular value or category appears in a dataset relative to the total number of observations.

Crosstabulation

A tabular summary of data for two variables. The classes for one variable are represented by the rows; the classes for the other variable are represented by the columns.

Variables

Elements, characteristics, or attributes that can take on different values and are used in scientific research or statistical analysis.

Stem-and-Leaf Display

A graphical method of displaying quantitative data to assess its distribution, by dividing each data point into a "stem" and a "leaf".