Computer scienceFundamentalsSQL and DatabasesBasics SQLIntroduction to SQL

Basic data types in SQL

Theory

Create a car

Report a typo

The table Car has the following columns:

  • an integer identifier
  • a textual description of a color
  • an amount of the annual petrol usage
  • the price in US dollars
  • whether it is electric

Match the column names with the corresponding data types.

Match the items from left and right columns
annual_petrol_use
id
color
price
electricity
VARCHAR(20)
DECIMAL(20,2)
INTEGER
BOOLEAN
REAL
___

Create a free account to access the full topic