Crossover for Work Technical Support Expert interview questions

A complete waste of time; avoid at all costs. After responding to a job ad, you are sent an email to then complete assessments. The first is an aptitude test where you have 15 minutes to answer 15 multiple choice questions. These range from mathematics, to word knowledge and associations, pattern recognition, and the like. Total BS, but whatever. Next came "can you speak English," where you have to take about 10 minutes listening to and repeating sentences. This had the added bonus of being pretty insulting on top of already being a waste of time. Then comes the "practical skills," which involved writing a bunch of MySQL statements. For someone who works with that regularly, these likely would have been no problem. I'm not one of those people. If I see "SQL" in a job posting, I know not to waste my time. At no place in the job posting, nor in their "what to expect email," nor anywhere prior to the actual test did they mention having to code. I was able to get the bulk of the code correct, but couldn't change NULL to "unknown" in the output. The score is binary pass/fail. You either get everything right, or it's entirely wrong. Syntax, thought process, none of that gets scored.