Answer for Error code caused by SQL query given in 'Primary key constraints' SQL lesson

https://365datascience.com/dwqa-answer/answer-for-error-code-caused-by-sql-query-given-in-primary-key-constraints-sql-lesson/ -

Hi MeredithB!

Thanks for reaching out!

With the first query, you’ve defined two primary keys – date_of_purchase, and purchase_number. And you can’t have more than one primary key (and that’s what the error message suggests).

Your second query is correct – it contains only one primary key, purchase_number.

Please revise the code we’ve suggested – we can’t have shown two primary keys, I believe!

Hope this helps.
Best,
Martin

 

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy