Modernizing Medicine Interview Question

related to my previous experience and SQL queries