Softeon Interview Question

Some queries questions using having clause