Hello,

Maybe you want to try an Italian Moka pot.

Maybe not so suitable for office, but great for home if you like that kind of coffee.

Much different from French press...

Nice question, but awarding points for and titling "Group by" is a big hint, so alternatives without group should be automatically excluded.

Anyway nice question and nice count distinct trick.

All rows are returned.

Probably author intended to put a trap on line 1 with 'coffee.' but there is also a ' coffee ' at the beginning.

I suppose the score...

I agree, I supposed it was a trick: you...

I tried on Sql 2005,

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Line 4

Must declare the scalar...