What's the difference between Automatic vs Manual Transmission

What is better Automatic or Manual Transmission?