Vizient interview question

SQL Join and how you can build API and unit test