Tweets posted from which city has a higher number of average likes, Bangkok or Chiang Mai?
"Bangkok" and "Chiang Mai" are both City; average number of like = Divide (Sum(Likes), Count(TweetID))
SELECT SUM(CASE WHEN T2.City = 'Bangkok' THEN Likes ELSE NULL END) / COUNT(CASE WHEN T2.City = 'Bangkok' THEN 1 ELSE 0 END) AS bNum , SUM(CASE WHEN City = 'Chiang Mai' THEN Likes ELSE NULL END) / COUNT(CASE WHEN City = 'Chiang Mai' THEN TweetID ELSE NULL END) AS cNum FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T2.City IN ('Bangkok', 'Chiang Mai')
database name:db_id social_media
location table location Cols: location id dtype integer, Country dtype text, State dtype text, state code dtype text, City dtype text, 
user table user Cols: user id dtype text, Gender dtype text, 
twitter table twitter Cols: tweet id dtype text, Weekday dtype text, Hour dtype integer, Day dtype integer, language dtype text, is reshare dtype text, Reach dtype integer, retweet count dtype integer, Likes dtype integer, Klout dtype integer, Sentiment dtype real, text dtype text, location id dtype integer, user id dtype text, 
