Pergunta de entrevista da empresa Asiatic London

What is the difference between VLOOKUP and XLOOKUP in Excel? What is the difference between WHERE and HAVING in SQL?