Hi @Aviral Bhardwaj​ 

Thank you for the answer.

My question is more about using analyze table command followed by describe extended on the temp view that is created. you are using the right dataset as shared in the ss. I have shared all the sequence of commands which lead to the state of getting null stats.