This is a really cool comparision table, comparing 14 effect categories of the 6 mostly used drugs (Alcohol, Amphetamine, Cannabis, Cocaine, Opiates, Tobacco).

Example: in the category Deaths worldwide:

Alcohol: Millions yearly. Mostly caused by heart and liver diseases, accidents and belligerance. Relatively few fatal doses.

Amphetamine: Thousands yearly. Mostly caused by belligerance and irrational behavior.

Cannabis: Thousands yearly. Mostly caused by police actions and accidents.

Smoking: Millions yearly. Mostly caused by lung cancer, emphysema, heart disease, reduced resistance to infections and a few by fire.

Earlier on the nest: The bar and the coffeeshop part 1, 2, 3, 4, 5