Unable to get pass instruction in PostgreSQL

Hey guys, I am currently new to PostgreSQL. Can anyone shine some light? Why is my code wrong? I am stuck in the second instruction.

Lesson link: https://www.codecademy.com/paths/full-stack-engineer-career-path/tracks/fscp-sql-for-back-end-development/modules/fscp-sql-creating-updating-and-deleting-data/lessons/postgresql-constraints/exercises/postgresql-data-types

My code:

CREATE TABLE attendees(
  id integer,
  name varchar,
  total_tickets_reserved integer,
  standard_tickets_reserved integer,
  vip_tickets_reserved integer
)

INSERT INTO attendees VALUES (1, 'John Smith', '2.5', 1, 1);

On your INSERT statement…

I have a feeling that’s a string :upside_down_face:

2 Likes

Never mind, I solved my problem and passed the second instruction by adding a semicolon here :joy::

CREATE TABLE attendees(
  id integer,
  name varchar,
  total_tickets_reserved integer,
  standard_tickets_reserved integer,
  vip_tickets_reserved integer
);  <--- Semicolon
1 Like