Computer scienceFundamentalsSQL and DatabasesBasics SQLIntroduction to SQL

Basic data types in SQL

Theory

Fill in the blanks for SQL table creation

Report a typo

Given an SQL query for creating a 'Students' table and inserting some data into it, there are a few crucial data types missing. Your task is to correctly fill in the blanks in the given SQL code to ensure it correctly creates the table with an 'ID' column of a type suitable for a unique identifier, a 'FullName' column for strings of characters, and a 'GPA' column for decimal numbers with precision and scale.

Fill in the gaps with the relevant elements
CREATE TABLE Students (
  ID ,
  FullName (100),
  Age INT,
  GPA (3,2)
);

INSERT INTO Students (ID, FullName, Age, GPA)
VALUES (1, 'John Doe', 20, 3.5);

SELECT * FROM Students;
INTVARCHARDECIMAL
___

Create a free account to access the full topic