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: What is the percentage of application with 4.7 rating having more positives sentiment than negative sentiment?
Evidence: percentage = DIVIDE(SUBTRACT(SUM(Sentiment = 'Positive')), (SUM(Sentiment = 'Negative')), SUM(Sentiment = 'Negative')) as percentage; having more positive sentiment than negative sentiment refers to Sentiment = 'Positive'>Sentiment = 'Negative';

SQL:
SELECT CAST(COUNT(CASE WHEN ( SELECT COUNT(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE NULL END) - COUNT(CASE WHEN Sentiment = 'Negative' THEN 1 ELSE NULL END) FROM user_reviews GROUP BY App ) > 0 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = 4.7