Write the code for an ORDER BY clause that sorts a table into numeric sequence by the data in the PartCode column if that column contains whole numbers that are stored with the varchar data type: _____________________________________________________

When you use the implicit syntax for coding inner joins, the join conditions are coded in the ____________ clause.

To concatenate character strings, you use the _____________ operator in a string expression.

A SELECT statement that includes aggregate functions is often called a/an _____________________________ query.

The rows in a table are kept in the sequence that’s based on its  __________________________ index.

The ________________ clause of the SELECT statement names the table that contains the data to be retrieved.

In most cases, the join condition of an inner join compares the primary key of one table to the ____________________ key of another table.

A view is a SELECT statement that is stored with the ______________.

To maintain _________________________________, if you delete a row in a primary key table, you must also delete any related rows in foreign key tables.

The IIF function determines the value it returns based on a/an ____________________ expression.