Challenge : Bobby's Hobbies step three problem – Khan Academy Centre d'aide

Comment pouvons-nous vous aider ?

Morris Chang

6 avril 2020 02:14

0

I did this on step three

SELECT * FROM hobbies WHERE person_id = 1;

How is this correct

Nouvelle publication

1 commentaire

AD Baker

9 avril 2020 15:33

Modifié
1

Actions pour les commentaires Permalien
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.

Vous devez vous connecter pour laisser un commentaire.