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 average rating of comic category apps? How many users hold positive attitude towards this app?
Evidence: average rating = AVG(Rating where Category = 'COMICS'); number of users who hold a positive attitude towards the app refers to SUM(Sentiment = 'Positive');

SQL:
SELECT AVG(T1.Rating) , COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'COMICS'