Ultimate Medical Academy interview question

There were 4 SQL questions that were explained using a sample data set if two tables (transaction table and dimension table) first two were easy aggregations and the last two required correlated subqueries: calculate average time pertaining to all calls made to leads and the last one was to find ratio of leads vs non lead calls. These were great to test the concepts pertinent to SQL querying.