Challenge : Bobby's Hobbies step three problem – خان اکیڈمی ہیلپ سینٹر

How can we help?

Morris Chang

اپریل 06, 2020 02:14

0

I did this on step three

SELECT * FROM hobbies WHERE person_id = 1;

How is this correct

New post

1 comment

AD Baker

اپریل 09, 2020 15:33

Edited
1

Comment actions Permalink
The instructions for Step 3 of Bobby's Hobbies are:

Now, add an additional query that shows only the name and hobbies of 'Bobby McBobbyFace', using JOIN combined with WHERE.

The code

SELECT * FROM hobbies WHERE person_id = 1;

is a query that shows all of the fields (not only the name and hobbies) of ID 1 (Not 'Bobby McBobbyFace',- to the auto-grader, this makes a difference). Also, there is no JOIN clause in this query.

Please sign in to leave a comment.