Problem: Sometimes, it might be possible that we need not null value only from particular columns and if all column have null value then we provide a default value. Lets understand this by a general and very interesting example suppose a friend come to your house and you want to give him a treat …