Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Custom logging
Loading Customers
8. The newsletter table


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)


Create a SELECT statement that returns all records from the newsletter table, sorted by the newsletter_name and type columns in ascending order.