Endpoint Clinical interview question

Write SQL Query which pulls data from two tables. [ Table shared during interview] ? Write query to group the data obtained from the above query? Question about 'Having ' clause