Pregunta de entrevista de Freddie Mac

Type 2 dimension, Difference between having and where in SQL, Snowflake vs Star schemas.