Criteria 1: Report: Are conclusions clear and supported by evidence in all eight answers?
Score Level: 1 (Does not meet expectations)
Comment(s): I see how you were querying on a single user. However in this project, we were looking for more broad answers that showcased the different campaigns and sources, and what they were responsible for in terms of getting the user to make a purchase or getting the user to the website. I did not see the output that was expected, and there were several answers to questions that were missing. These are highlighted in other issues that I posted.
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
Score Level: 1 (Does not meet expectations)
Comment(s): Most of your queries, although close, did not give the expected output. They did not answer the questions asked or query the correct data.
Criteria 3: Query Formatting
Score Level: 3 (Meets expectations)
Comment(s): Most of your code was formatted correctly. The only issues I really saw was with indentation. Make sure that your indentation stays consistent throughout your code and adheres with the style guide
Criteria 4: Understanding underlying concepts and terminology
Score Level: 2 (Approaches expectations)
Comment(s): Although most of the queries were not quite correct and gave the wrong output, you did show a good understanding of the terminology that was being used as well as the concepts that this course was trying to teach.
Overall Score: 7/16
Overall this project would have been great if we were looking for different examples of a specific user. It would have been more easily understood if you had queried on a single user throughout the code and showed me his/her journey throughout the website in addition to answering the questions asked. That would have been something above and beyond. Most of this project showed that you still need some work understanding how to use SQL queries and their output in order to answer a specific set of questions. I would suggest running through Codecademy's SQL course as well as taking this course again. If you do that you will definitely be a pro by the end of it!
Hi Kay Marie,
Thank you for your review. I somehow had the wrong questions. I have completed another set of questions and waiting for a review. Will you be reviewing my work again or someone else?
Rubric Score
Criteria 1: Report: Are conclusions clear and supported by evidence in all eight answers?
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
Criteria 3: Query Formatting
Criteria 4: Understanding underlying concepts and terminology
Comment(s): Although most of the queries were not quite correct and gave the wrong output, you did show a good understanding of the terminology that was being used as well as the concepts that this course was trying to teach.
Overall Score: 7/16
Overall this project would have been great if we were looking for different examples of a specific user. It would have been more easily understood if you had queried on a single user throughout the code and showed me his/her journey throughout the website in addition to answering the questions asked. That would have been something above and beyond. Most of this project showed that you still need some work understanding how to use SQL queries and their output in order to answer a specific set of questions. I would suggest running through Codecademy's SQL course as well as taking this course again. If you do that you will definitely be a pro by the end of it!