Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Working with Views

Updatable views
Materialized views
Summary
9. Review

Instruction

Here's the question for you!

Exercise

A website that allows people to upload and view videos has the following table:

CREATE TABLE video (
  id integer PRIMARY KEY,
  author_id integer,
  posted date,
  views integer
);

Create a materialized view named popular_videos_2018 that will contain all videos from 2018 having more than 100,000 views.