On “queries projects and applications” of data science path, the “hint solution” is confusing me.
It gives us the option to use ‘where’ ‘AND’, but it also shows another solution using ‘Between’.
Issue i have is that, using ‘Between’ option on a text data type as ‘1980-01-01’ this is not including that day, since its a text data type and not integer.
On Writing queries it is explained to us the difference when the data is a ’ ’ type of date or a number type of data. Number is inclusive but data isn’t inclusive, meaning we would need to type 1980-01-02 if we wanted to actually include the first day of January.
Am i being wrong here, or is the solution given to us actually wrong on the exercise?