should only contains data for 2nd Jan 2020 expect 2020.01.02~first exec distinct date from lapTable
Test 2.2.3
should contain all columns for 2nd Jan 2020 expect lapTable~select from lap where date in 2020.01.02
And a tip:
I would also recommend the use of
\l f1
to load in your database - you will need to make sure you are at the right location to do this hint you can use \cd to change directory. Check out the materials in the module on partitioned databases for a reminder - available in the associated jupyter notebooks provided.
All of my section 1 and 2 quizzes are now passing (with the exception of 2.5, which I am in the process of attempting). Thank you very much.
I think the issue for me was as follows:
1) I was deriving my ‘lapTable’ from ‘lap’.
So I was loading in my ‘lap’ table (which was derived from the .f1.createLapTable function, which omits/removes the date column).
Passing quizzes 2.2.2 and 2.2.3 requires the presence of a date column in your ‘lapTable.’ This will require the artificial addition of a date column to ‘lapTable’ in the case where an individual is deriving ‘lapTable’ from ‘lap’.
I hope this all makes sense and that my confusion was reasonable. Hopefully no one will have this same issue in the future. I really appreciate all the feedback and I welcome any further questions/comments. Cheers!