Identify precedence in evaluating an arithmetic expression within a SQL statement. Specify an alias for a column heading when extracting data from a table. Concatenate multiple columns that are selected from a table. Display rows that match a list of values by using the IN operator. Perform wildcard searches by using the LIKE operator.
Display rows containing null values by using IS NULL operator.
Identify precedence rules when evaluating conditions that use comparison and logical operators. Sort rows retrieved by more than one column. Identify the two types of SQL functions. Identify the features of a single-row function. Round a value to a specified decimal place by using the Round function.