Hi,
Please help me resolve these issues. The following tasks are not completing.
The tests keeps failing despite the sql appearing correct.
Each “planet” should have a foreign key that references one of the rows in star
Each “moon” should have a foreign key that references one of the rows in planet
The planet and moon table all show their foreign keys when viewed in the terminal. Here is the gitpod snapshot link:
https://gitpod.io#snapshot/f96fc88e-326a-4752-82df-e95f000fdd95
Help me fix this thanks!
ILM
January 24, 2025, 9:48am
2
do you have rows in the planet and moon tables?
Yes I have,
There are 20 rows in moon and 12 rows in planet. Here are the table details for both tables shown in the images below:
ILM
January 25, 2025, 8:42am
5
in the planet
table, what are the values in the star_id
column?
1 Like
Thanks for the hint. I populated all the tables with the appropriate data respecting the foreign keys and everything worked perfectly.
I really appreciate your advice. I hope you will be with me right up to the end!