On Summarizing Data Section After Executing to restore the Whole Database and restoring it , My Results are not matching , could kindly anyone solve it , or tell me my mistake, this is on section summarizing data and using aggregate functions
I think we need more details before we can help you.
What do you expect to see?
And what do you see?
Hey , thank you for reaching out , wait let me show you
on section - Summarized Data
- Aggregate Functions after completing the exercise the output isn’t matching with Mosh’s output
My Output :
date_range total_sales total_payments what_we_expect
First Half of 2019 1539.07 212.97 1326.10
Second Half of 2019 1521.36 244.03 1277.33
TOTAL 2590.60 361.38 2229.22
Mosh’s Output
I get the same result as you, so there must be a discrepancy in the two dataset (Mosh and the one he provided us).
But when investigating the payment results, it matches the data in the table, so continue with the course and be aware of the possible differences there can be.