Whenever you're ready, walk me through how you'd approach this.
Explain the difference between the WHERE and HAVING clauses in SQL. In what scenarios would you use each clause? Provide examples to illustrate your points.