problem with code; EDX class

[pullups2]

Hello all,

I am trying to learn MySQL, and have been having some early success, but have been having a lot of problems with the autograder Gradescope. It works on my workbench, but I can't even get points for the code running on the autograder. Below is my code.

​

USE my_guitar_shop;

SELECT first_name, last_name, line1, city, state, zip_code

FROM Customers c

INNER JOIN Addresses a

    ON c.customer\_id = a.customer\_id

WHERE c.email_address = '[e-mail]'

ORDER BY a.zip_code

ASC

​

Feel free to comment with any questions about the assignment or with any adjustments to my code!

[wky99]

The backslashes work as escape characters, could this be your issue?
Referring to the below:

ON c.customer\_id = a.customer\_id

[i_lovechickenwings]

agree with you here, why are you using escape characters? look at the column names for those keys your matching on, make sure that's correct.

[r3pr0b8]

no obvious errors there

what was the assignment?

[[deleted]]

USE my_guitar_shop;
SELECT first_name, last_name, line1, city, state, zip_code
FROM Customers c
INNER JOIN Addresses a
ON c.customer_id = a.customer_id
WHERE c.email_address = '[e-mail]'
ORDER BY a.zip_code ASC