One time I was doing an in person SQL exam White board style. I write all the queries perfectly only for one of them I used a where clause instead of having. They rejected me for that. Like wtf in the real world it throw an error and I fix it in two seconds. Who codes perfect straight through 100% of the time. These technical exams don’t emulate the real work environment