It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Custom logging
Loading Customers
Subscriptions
8. The newsletter table
Congratulations

Instruction

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)
);

Exercise

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