Database schema:

CREATE TABLE location (
	"LocationID" INTEGER -- example: ['2', '1'],
	"Country" TEXT -- example: ['Algeria', 'Albania'],
	"State" TEXT -- example: ['Elbasan', 'Tirane'],
	"StateCode" TEXT -- example: ['AL', 'DZ'],
	"City" TEXT -- example: ['Elbasan', 'Tirana'],
	PRIMARY KEY ("LocationID")
)


CREATE TABLE twitter (
	"TweetID" TEXT -- example: ['tw-682712873332805633', 'tw-682713045357998080'],
	"Weekday" TEXT -- example: ['Friday', 'Thursday'],
	"Hour" INTEGER -- example: ['17', '18'],
	"Day" INTEGER -- example: ['1', '31'],
	"Lang" TEXT -- example: ['_u', 'en'],
	"IsReshare" TEXT -- example: ['FALSE', 'TRUE'],
	"Reach" INTEGER -- example: ['1810', '44'],
	"RetweetCount" INTEGER -- example: ['0', '5'],
	"Likes" INTEGER -- example: ['0', '131'],
	"Klout" INTEGER -- example: ['53', '35'],
	"Sentiment" REAL -- example: ['0.0', '2.0'],
	text TEXT -- example: ['We are hiring: Senior Software Engineer - Proto ht', 'RT @CodeMineStatus: This is true Amazon Web Servic'],
	"LocationID" INTEGER -- example: ['3751', '3989'],
	"UserID" TEXT -- example: ['tw-3179389829', 'tw-40932430'],
	PRIMARY KEY ("TweetID"), 
	CONSTRAINT fk_twitter_location FOREIGN KEY("LocationID") REFERENCES location ("LocationID"),
	CONSTRAINT fk_twitter_user FOREIGN KEY("UserID") REFERENCES user ("UserID")
)


CREATE TABLE user (
	"UserID" TEXT -- example: ['tw-10000632', '\x1anknow531394'],
	"Gender" TEXT -- example: ['Unknown', 'Male'],
	PRIMARY KEY ("UserID")
)

Question: Tweets posted from which city has a higher number of average likes, Bangkok or Chiang Mai?
Evidence: "Bangkok" and "Chiang Mai" are both City; average number of like = Divide (Sum(Likes), Count(TweetID))

SQL:
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')