Pregunta de entrevista de Ingram Micro

What is difference between where and have statement in SQL?