Challenge : Bobby's Hobbies step three problem – Khan Academy yordam markazi

Qanday yordam kerak?

Morris Chang

April 06, 2020 02:14

0

I did this on step three

SELECT * FROM hobbies WHERE person_id = 1;

How is this correct

Yangi maqola

1 sharh

AD Baker

April 09, 2020 15:33

O’zgartirildi
1

Sharhlar bilan harakatlar Doimiy havola
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.

sharhsiz qoldirish uchu Xizmatga kiring