Criteria 1: Report: Are conclusions clear and supported by evidence in all eight answers?
Score Level: 2
Comment(s): Some of your answeres are missing text, and/or query results. However, related queries are uploaded in a separate .sql file.
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
Score Level: 4
Comment(s): All queries accurately retrieve the data intended. Good job including GROUP BY statement to group the result-set and make interpretation easier!
Criteria 3: Query Formatting
Score Level: 4
Comment(s): Queries adhere to at the rules of the style guide. Good work using aliases to rename the columns and using indentation to organize your subqueries, both make your queries more readable!
Criteria 4: Understanding underlying concepts and terminology
Score Level: 4
Comment(s): Your report demonstrates understanding of both the business problem and dataset. The well written SQL queries shows that you really thought about all components of the data and how they link together. At the end of report, the recommendations you made demonstrate that you understand how to solve the business problem and give a solution based on the data analysis results.
Overall Score: 14/16
Overall, great job! The way you supported your recommendations serves as evidence for your conclusions.
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?
GROUP BYstatement to group the result-set and make interpretation easier!Criteria 3: Query Formatting
Criteria 4: Understanding underlying concepts and terminology
Comment(s): Your report demonstrates understanding of both the business problem and dataset. The well written SQL queries shows that you really thought about all components of the data and how they link together. At the end of report, the recommendations you made demonstrate that you understand how to solve the business problem and give a solution based on the data analysis results.
Overall Score: 14/16
Overall, great job! The way you supported your recommendations serves as evidence for your conclusions.