Challenge : Bobby's Hobbies step three problem – Khan Academy Help Center - Hungarian (BETA)

Miben segíthetünk?

Morris Chang

2020. április 6. 2:14

0

I did this on step three

SELECT * FROM hobbies WHERE person_id = 1;

How is this correct

Új bejegyzés

1 hozzászólás

AD Baker

2020. április 9. 15:33

Szerkesztve
1

Hozzászólás-műveletek 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.

Hozzászólások írásához jelentkezzen be.