Stuck on SQL Part 3 Question 2: Bobbies Hobbies JOINs

Can you post the code you added in step 1 for the new entries?

Hey Dylan,  

  I was confused by how to number the hobbies. When I would try to work on step 2/3, my newly inserted values didn't seem to populate in the table and I am not sure why. Thank you!

INSERT INTO persons (name, age) VALUES ("Bobby McBobbyFace", 12);
INSERT INTO persons (name, age) VALUES ("Lucy BoBucie", 25);
INSERT INTO persons (name, age) VALUES ("Banana FoFanna", 14);
INSERT INTO persons (name, age) VALUES ("Shish Kabob", 20);
INSERT INTO persons (name, age) VALUES ("Fluffy Sparkles", 8);
INSERT INTO persons (name, age) VALUES ("Nelly Bluth", 13);

CREATE table hobbies (
id INTEGER PRIMARY KEY AUTOINCREMENT,
person_id INTEGER,
name TEXT);

INSERT INTO hobbies (person_id, name) VALUES (1, "drawing");
INSERT INTO hobbies (person_id, name) VALUES (1, "coding");
INSERT INTO hobbies (person_id, name) VALUES (2, "dancing");
INSERT INTO hobbies (person_id, name) VALUES (2, "coding");
INSERT INTO hobbies (person_id, name) VALUES (3, "skating");
INSERT INTO hobbies (person_id, name) VALUES (3, "rowing");
INSERT INTO hobbies (person_id, name) VALUES (3, "drawing");
INSERT INTO hobbies (person_id, name) VALUES (4, "coding");
INSERT INTO hobbies (person_id, name) VALUES (4, "dilly-dallying");
INSERT INTO hobbies (person_id, name) VALUES (4, "meowing");
INSERT INTO hobbies (person_id, name) VALUES (5, "sleeping");

I made the same mistake. When adding Nelly Bluth you don't need to specify an ID number as this is added automatically. Nelly is assigned ID 6 as she is the 6th person in the table.

When you inserted a line into the hobbies table you added it to person_id 5 which is 'Fluffy Sparkles' so when you run the query, Nelly's hobby of 'sleeping' gets attached to Fluffy (as person 5) and therefore Nelly is not listed at all as she has no hobbies.