For the questions on SQL operators " In the ‘titles’ table, what is the number of records WHERE the employee number is greater than 200000 OR their title does NOT contain ‘engineer’?" I have tried many things and have been stuck for days on this now, I feel like I am missing something very simple. Can someone point me to help? Thank you.
About 10 minutes after posting this I got it. Not clear on it still but the LIKE operator got me an answer that was accepted.
Hi im doing this module too and came across that the accepted value of the answer isnt correct as should be the value of the rows extrapolated by the regular expression.
Compared with wc -l which counts lines of rows after exporting the output from select to confirm and this question needs to be fied by support.
PoC attached for future reference
