My assignment notebook file is not running properly. All text is displayed as raw code and not code/markdown cells.
I have tried the following, but there’s no change;
The only notable feedback that I haven’t been able to work around is this: command ‘code-runner.run’ not found
Any help?
Hello @peter_w,
I can see the notebook not loading properly, if you haven’t tried a different browser, I suggest you do. Clearing your cache and cookies could also help and turn-off ad-blocking software as well. When updating did you follow the instructions, it says somewhere it will have no effect if you dont rename/delete the previous file. Thank you
Looks to me like you’re not viewing it as markdown. What options do you have in the View menu?
Hi, @Georgios & @TMosh . Thanks for the suggestions. I think I’ve found a solution to the problem.
I selected ‘metadata’ and the notebook reloaded properly. Everything seems to be working fine so far.
Thanks again 
Hi All,
I have been literally one week trying to pass over the Assignment 3 Advanced SQL Queries, particularly on the graded Exercise 3 where the Expected Output vs my delivered output is somehow close, however, the grader seems not to like it and marks 0/10 every time. I need help as times is flying by.
Hello @amiguel,
It looks like you are using the rental_id instead of the film_id. Also in the expected output you are in part 3.2 and only later in part 3.3 you need to JOIN to find the category names. Hope it helps
Hi @amiguel, you selected in the film_category the rental_id and get those numbers. To fix it you need to select DISTINCT category.name and film_id. Also fix the film_category_count to select COUNT(film_id). Try to get the correct output for films. If you need anuthing try to make a new topic, this one is solved. Cheers
Hi @Georgios I am having some issues with my lab. I solved all the exercises, but it only shows a score of 60%. My lab also displays some duplicate exercises, like 10.2 = 10.3 and 11.2 = 12.
Hello @valdyferreis,
One thing I can see clearly from the output is that you need the correct total_amount. A second thing is to check the cell has the tag of the exercise to get graded (e.g. exercise 10 should have the ex10 tag).
I could give instructions to add the cell tag, just right click inside the cell and there’s an option there. I hope it helps
Hello @valdyferreis,
I can tell from the total amount that you have the wrong dates in exercise 1 (2005-07-31 instead of 2005-08-01).
You count one day less and which cause the total_amounts to be smaller.
If you have duplicate exercises for some reason and want to get a fresh notebook (and keep the old one as well). Follow these instructions. Thanks
Hello @Georgios
I added the tags, but it didn’t work. It also affected some cells.”
Hello,
Did you fix exercise 1, which other has problem and still don’t pass. You should also check to use the correct column names in the output (films instead of film_count etc). Try to rename this notebook and get a new one with the instructions above if you still have an issue, Hope it helps
“Hi, @Gergio, can you give me some instructions to rename the notebook?”
Hello @valdyferreis,
1)right click on the name of the C3W3_Assignment file and choose rename, choose a different name like old_C3W3_Assignment.ipynb
