Question

O Substring

Fill in the blank: When describing a SUM function, the ___ is =SUM(value 1 through value 2).
O standard
O script
syntax
O structure

Answer 1

Last Name First Name Phone Number

Hagans Jim 604-232-3232

Wong Bruce 604-244-2322

Table 16.1. Employees table.

In this next example, we will use a Publishers table (Table 16.2). (You will notice that Canada is mispelled in the Publisher Country field for Example Publishing and ABC Publishing. To correct mispelling, use the UPDATE statement to standardize the country field to Canada – see UPDATE statement later in this chapter.)