Eugenia Alekseeva
Last answered:

01 May 2023

 Posted on:

27 Apr 2023
0

Resolved: >'2000-01-01' for year=2000 is incorrect

in Advanced SQL / Referring to CTEs in a WITH Clause

I believe we should use >='2000-01-01' when we need to retrieve data instead of >'2000-01-01', otherwise we will miss the employee 108201 who was hired presisely on 2000-01-01

1 answers ( 1 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

01 May 2023
0

Hi Eugenia!
Thanks for reaching out.


You are right! Thanks for spotting it!


Best,
Tsvetelin

Helpful answer

Submit an answer

related questions

Eugenia Alekseeva
0
8
query seems incorrect
Sarah Massengill
0
6
Course exam Q6's answer is (not) wrong <-edited I missed "pick the **incorrect** answer"
Eugenia Alekseeva
0
4
Resolved: Answer to an exam question seems correct but marked incorrect