Pergunta de entrevista da empresa Freddie Mac

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