Another tiny mistake in SQL1: Essentials Course Note PDF - on page 107, in practice s102s03's an

[dxiao2017]

Hi Tom, (since I bring up all this discussion) for your last question, this is my understanding so far: the basic idea of designing that question was to let learners practice create variables, use formats, select rows, and order observations according to the datetime variable (so that the answer can be verified through the earliest transaction on 01DEC2018). And then there was feedback from learners suggesting that learning to display only the date without the time part was necessary, and the datepart() function was added into the question, but ordering by original datetime remain unchanged. While update the materials, something also changed either with the datasets or the question (which asks to pick a row or column value to verify learners' answer), and these lead to the answer for the question became big burger in that version of pdf which was produced then.

[dxiao2017]

Hi Cynthia, thanks a lot for clarifying and information, I indeed was looking at the pdf(of not updated version) instead of the html webpage. I accessed the online course material through 7 days free access and now I am using the course note pdf without accessing the e-learning version. And as an "old" learner (I got my BA and out of college almost 30 years ago, btw 😀) I think this community is very helpful.

[dxiao2017]

Hi Tom, I agree with you on this point, although it generates only a NOTE (not a WARNING), I do not feel comfortable to order my data (especially when the dataset and output table are my final product) by a variable that is invisible or not shown, I always need to see it and be certain with the data and codes.