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

Data Types in SQL

Introduction
Final Quiz
7. Question 6
Summary

Instruction

Perfect! The last exercise will check if you remember how to modify existing structures.

Exercise

A company which organizes mountain trips created the following table:

CREATE TABLE mountain_range (
  id integer PRIMARY KEY,
  country_id integer,
  name varchar(16),
  highest_point decimal(3, 1)
);

They now want to introduce a few changes to the table and need your help!

  1. Add the auto-generation of IDs with the option to provide your own values.
  2. Extend the name column to accept up to 64 characters.
  3. Extend the highest_point column to accept up to 6 digits, 2 of which should be after the decimal point.