We'll be working with two other tables in the upcoming exercises: newsletter and subscription.

Let's review the first one. The newsletter table contains all newsletter names along with their frequency (daily, weekly, monthly, yearly, etc.) and type (letter, email, etc.). See the table structure below:

CREATE TABLE newsletter (
  id serial not null primary key,
  newsletter_name character varying(256),
  frequency character varying(32),
  type character varying(32)
);