Select columns of a typed table

A query on a typed table is no different from a query on any other table. For example, the following query uses the asterisk symbol (*) to specify a SELECT statement that returns all columns of the employee table.
Figure 1: Query
SELECT * FROM employee
The SELECT statement on the employee table returns all rows for all columns.
Figure 2: Query result
name        Paul, J.
address     ROW(102 Ruby, Belmont, CA, 49932, 1000)
salary      78000

name        Davis, J.
address     ROW(133 First, San Jose, CA, 85744, 4900)
salary      75000
⋮
The following query shows how to construct a query that returns rows for the name and address columns of the employee table.
Figure 3: Query
SELECT name, address FROM employee
Figure 4: Query result
name        Paul, J.
address     ROW(102 Ruby, Belmont, CA, 49932, 1000)

name        Davis, J.
address     ROW(133 First, San Jose, CA, 85744, 4900)
⋮