Simple one. 15% wrong answers are there b'cos few of them just select what ever they want to without even looking at question

Too big code i just ran the code. but yeah i did learned bit about date and then got lost...

Great thanks. didn't know that. learnt something new.

Excellent question. i thought # is not valid table name but googling suggest that it's valid.

Easy point.

Agree How can people chose misspelling for podcasts?

I didn't get any error. i got 0.00 i wonder why

Awesome question. didn't know nullIf can be these much tricky...

I selected None as i got lost in the logic. also i thought 0 & none would be same isn't it?

Thanks, didn't know that rollback didn't effect declared variables.

Thanks, i was under the impression that we have to use Having with Group by only and also explanation is clear enough to understand how it works.

yes Different region will have different answers but when no regions mentioned we normally take US as a default region specially when we talk about dates.

Simple

Good question

got Confused between across all state & each state and got it wrong...:unsure: