Question d’entretien chez Freddie Mac

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