Ingram Micro Interview Question

What is difference between where and have statement in SQL?