The medium round checks that you can define a measure and turn the definition into SQL. Interviewers ask what goes in the numerator and the denominator, which rows are left out and why, and what a query really computes.
A strong answer states the definition, names the rows it leaves out, and says what goes wrong if you skip that step: "The no-show rate is no-shows over completed plus no-shows. Cancellations stay out, or the rate looks higher than it is."