-- Database schema
| playstore : App [ TEXT ] , Category [ TEXT ] , Rating [ REAL ] , Reviews [ INTEGER ] , Size [ TEXT ] , Installs [ TEXT ] , Type [ TEXT ] , Price [ TEXT ] , Content Rating [ TEXT ] , Genres [ TEXT ] | user_reviews : App [ TEXT ] user_reviews.App = playstore.App , Translated_Review [ TEXT ] , Sentiment [ TEXT ] , Sentiment_Polarity [ TEXT ] , Sentiment_Subjectivity [ TEXT ] |
-- -- Which apps have not been updated since year 2015 and what kind of sentiment users hold on it?

SELECT DISTINCT App, Sentiment FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE CAST(SUBSTR('Last Updated', -4, 4) AS INTEGER) < 2015 );