tcv-tclsbc
diff --git a/‎README.md
Lines changed: 24 additions & 0 deletions b/‎README.md
Lines changed: 24 additions & 0 deletions
@@ -568,4 +568,28 @@ GROUP_CONCAT(DISTINCT product) AS 'products'
 FROM Activities
 GROUP BY sell_date
 ORDER BY sell_date
+```
+
+[1341. Movie Rating](https://leetcode.com/problems/movie-rating/)
+
+```sql
+(SELECT name AS results
+FROM Users u
+LEFT JOIN MovieRating mr
+ON u.user_id = mr.user_id
+GROUP BY name
+ORDER BY COUNT(rating) DESC, name ASC
+LIMIT 1)
+
+UNION ALL
+
+(SELECT title
+FROM Movies m
+LEFT JOIN MovieRating mr
+ON m.movie_id = mr.movie_id
+WHERE DATE_FORMAT(created_at, '%Y-%m') = '2020-02'
+GROUP BY title
+ORDER BY AVG(rating) DESC, title ASC
+LIMIT 1 
+)
 ```