Uses of HAVING Clause

Question

I face difficulty in using HAVING clause of SQL, please provide complete example of HAVING clause alongwith output.