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

Understanding Indexes

Introduction
Recap
7. Part 4 – additional exercise
Summary

Instruction

One more exercise and then we're done!

Exercise

You're given the smartphone table again:

CREATE TABLE smartphone (
  id integer PRIMARY KEY,
  code varchar(32),
  manufacturer varchar(32),
  model varchar(32),
  price_usd decimal(10, 2),
  memory_gb integer,
  screen varchar(32),
  main_camera_mpx integer,
  release_date date
);

Older phones are very rarely bought. Create a partial index named partial_index_price on the column price_usd. Only include those phones which were released after Dec 31, 2015.