Persistent Systems Interview Question

in SQL, difference between where and having clause and star schema and snowflake difference