Abdul,
Gerald has given you a good explanation.
LETTING is similar and does the same as above (for the Having/Group By clauses)
One minor addition - use backtick for the bucket (keyspace) name beer-sample
(since it has a hyphen - special character)
For some reason the webpage does not display the backtick (I’m sure it was the same that happened when Gerald typed the syntax)