C3w3 lab grade not showing

The lab somehow is grading par my assignment. I do no think that I am only one with the issue. Enclosed is a sample.
Regards,

Hello @shamidou28,

The grader output must be identical to the expected output. You are using AS avg_up and avg_down but the correct columns are average_down and average_up instead. Could you check for other similar issues since the column names are case sensitive and other numbers must match the Exercise’s output. Thank you

Thanks for the info!

1 Like

I made the recommended corrections. The system would grade the attached exercise correctly.
Regards



Hello @shamidou28,

In Exercise 5 your names are in Capital, no need to use UPPER in your full_name column

In Exercise 3 you have an additonal row named New, in the WHERE statement use CEIL(AVG(films)) instead of AVG(films) (Exercise 3.1 uses CEIL)

In Exercise 2 use average_up instead of average__up (double _ spaces).

Hooe it helps

Thank your prompt reply!

Glad it fixed @shamidou28, you could remove the code, thanks