Database schema:

CREATE TABLE playstore (
	"App" TEXT -- example: ['Photo Editor & Candy Camera & Grid & ScrapBook', 'Coloring book moana'],
	"Category" TEXT -- example: ['AUTO_AND_VEHICLES', 'ART_AND_DESIGN'],
	"Rating" REAL -- example: ['3.9', '4.1'],
	"Reviews" INTEGER -- example: ['159', '967'],
	"Size" TEXT -- example: ['19M', '14M'],
	"Installs" TEXT -- example: ['500,000+', '10,000+'],
	"Type" TEXT -- example: ['Paid', 'Free'],
	"Price" TEXT -- example: ['0', '$4.99'],
	"Content Rating" TEXT -- example: ['Everyone', 'Teen'],
	"Genres" TEXT -- example: ['Art & Design;Pretend Play', 'Art & Design']
)


CREATE TABLE user_reviews (
	"App" TEXT -- example: ['104 找工作 - 找工作 找打工 找兼職 履歷健檢 履歷診療室', '10 Best Foods for You'],
	"Translated_Review" TEXT -- example: ["I like eat delicious food. That's I'm cooking food", 'This help eating healthy exercise regular basis'],
	"Sentiment" TEXT -- example: ['nan', 'Positive'],
	"Sentiment_Polarity" TEXT -- example: ['1.0', '0.25'],
	"Sentiment_Subjectivity" TEXT -- example: ['0.5333333333333333', '0.28846153846153844'],
	CONSTRAINT fk_user_reviews_playstore FOREIGN KEY("App") REFERENCES playstore ("App")
)

Question: List down app that does not have negative sentiment and give their average rating?
Evidence: doest not have negative sentiment refers to Sentiment! = 'Negative'; average = AVG(Sentiment_Polarity);

SQL:
SELECT T1.App, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment != 'Negative' GROUP BY T1.App