create type address as
(
  zip_code varchar(5),
  city     varchar(100),
  street   varchar(100)
);

create table contact
(
  contact_id       integer not null primary key,
  delivery_address address,
  postal_address   address
);

The above is an example using Postgres syntax

Back to the SQL Feature Comparison