The time-consuming fiend which is Programming Assignment: Deeper Analysis of the Movie Data with SQL

Course Q&A Data Analytics Professional Certificate Data I/O and Processing with Python and SQL
,
1

Hello Raymond and everyone in this digital realm!

Here, are screenshots for your records:

image
image1920Ă—1080 334 KB

image
image1920Ă—1080 344 KB

2

Hi @CamLiv8,

I can see from your screenshots that the first error is due to “object not found". In these cases it’s likely that the object being graded was deleted at some point, so probably the best thing to do here it to restart your notebook. You can check this post for more details.

Also note that for questions 2 to 5 your SQL query is being checked, so you should keep that variable as a string. I believe that once you restart your notebook you will be able to tackle these as well. Remember to follow the recommendations on how to write SQL queries as shown in the lesson.

Good luck with the assignment :blush:

2 Likes
3

Hello @imgabidotcom, it was my suggestion to start a new topic for a new question. The information in that previous topic was not quite likely to be useful for these new ones, and we can keep the topic short. When I reference a learner to an older post, it would be better that the post is short and focus on a single problem.

Cheers,
Raymond

2 Likes
4

ok @rmwkwok, clear :slight_smile:

I edited my comment above and removed that suggestion to avoid confusion.

1 Like
5

Thanks! Let’s get back to Cam’s question.

Cam, please follow the suggestions by @imgabidotcom. For your exercise 1, the “object” in the error message means the “variables”. Initially, the exercise has four variables being assigned with None and your task is to replace those Nones with correct answers.

If any of those variables is removed or any of their names is changed, it is a problem. Gabi’s suggestion to follow the steps in the link to get a new copy of the notebook would be a good way to restart.

2 Likes
6

Hello Raymond and @imgabidotcom!! Thanks again for the effort. Will put both your advice in action! Fingers crossed.

1 Like
7

HI ALL,thanks for your help. I still cannot get this working. It is also seriously holding me up.

8

Can you please show us the issues you are having (the messages from the grader)?

9

THANKS, all solved!

1 Like