Liquidity Group interview question

questions about hash-function, lock, mutex and semaphore and some joins in SQL