GEP Interview Question

SQL Queries of join Concurrency in DBMS