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: State the number of positive tweets from Ha Noi.
Evidence: positive tweet refers to Sentiment > 0; 'Ha Noi' is the State

SQL:
SELECT COUNT(T1.TweetID) FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T1.Sentiment > 0 AND T2.State = 'Ha Noi'