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
Modifying columns
Modifying identities
Modifying sequences
Summary
14. Question 1

Instruction

Let's get started.

Exercise

We wanted to create a table to keep track of car rides. We used the following script:

CREATE TABLE car_ride (
  id integer PRIMARY KEY,
  start_place varchar(32),
  end_place varchar(32),
  distance decimal(4, 2)
);

However, we need to record longer distances now. Your task is to change the distance table so that it stores decimals of up to 6 digits, of which 2 are after the decimal point.