Note: I have tried all the querries below on MySql.
Some of above querries have been asked in technical rounds of many big companies