Vizient Interview Question

SQL Join and how you can build API and unit test