In the previous exercise, we counted users who shared interests in their public profile. Another feature of the public profile of Bindle is the avatar image. If a user uploaded an avatar image it’ll be stored in the
avatar_url column inside the
Time to remember the
CASE statement In this exercise let’s make the next step in calculating feature acceptance and calculate the percentage of profiles that actually have an avatar.
NOTE: For simplicity let’s use integer numbers for calculating the percentage. Example: if the answer is ...