Ingram Micro interview question

whats the difference between a "have" and "where" sql statements