RED FLAG: RUN. Interview here is a total waste of time. My technical interview either shows that the interviewer does not know SQL at all or a complete lack of integrity - they just want to trick you with "problematic" questions and put you into awkward situation & discriminate. Can't believe I was given a SQL problem that itself is violating the concept & rule of SQL. Glad I was able to confirm the concepts later with other SQL pros I know, rather than end up questioning myself.

Applied online, received an email after 2 days from recruiter to schedule a phone screen. The recruiter called back during the scheduled phone interview date and mentioned that the position has been filled.