Ingram Micro interview question

What is difference between where and have statement in SQL?