Allo Health interview question

Excel basic vlookup, sql queries were asked, quite basic