add 1355

fishercoder1534 · fishercoder1534 · commit 0a82f1e4e82d · 2020-02-23T07:03:24.000-08:00
diff --git a/README.md b/README.md
@@ -909,6 +909,7 @@ _If you like this project, please leave me a star._ &#9733;
 
 |  #  |      Title     |   Solutions   | Video         | Difficulty    | Tag          
 |-----|----------------|---------------|---------------|---------------|-------------
+|1355|[Activity Participants](https://leetcode.com/problems/activity-participants/)|[Solution](../master/database/_1355.sql) || Medium |
 |1350|[Students With Invalid Departments](https://leetcode.com/problems/students-with-invalid-departments/)|[Solution](../master/database/_1350.sql) || Easy |
 |1341|[Movie Rating](https://leetcode.com/problems/movie-rating/)|[Solution](../master/database/_1341.sql) || Medium |
 |1327|[List the Products Ordered in a Period](https://leetcode.com/problems/list-the-products-ordered-in-a-period/)|[Solution](../master/database/_1327.sql) || Easy |
diff --git a/database/_1355.sql b/database/_1355.sql
@@ -0,0 +1,74 @@
+--1355. Activity Participants
+--
+--Table: Friends
+--
+--+---------------+---------+
+--| Column Name   | Type    |
+--+---------------+---------+
+--| id            | int     |
+--| name          | varchar |
+--| activity      | varchar |
+--+---------------+---------+
+--id is the id of the friend and primary key for this table.
+--name is the name of the friend.
+--activity is the name of the activity which the friend takes part in.
+--Table: Activities
+--
+--+---------------+---------+
+--| Column Name   | Type    |
+--+---------------+---------+
+--| id            | int     |
+--| name          | varchar |
+--+---------------+---------+
+--id is the primary key for this table.
+--name is the name of the activity.
+--
+--
+--Write an SQL query to find the names of all the activities with neither maximum, nor minimum number of participants.
+--
+--Return the result table in any order. Each activity in table Activities is performed by any person in the table Friends.
+--
+--The query result format is in the following example:
+--
+--Friends table:
+--+------+--------------+---------------+
+--| id   | name         | activity      |
+--+------+--------------+---------------+
+--| 1    | Jonathan D.  | Eating        |
+--| 2    | Jade W.      | Singing       |
+--| 3    | Victor J.    | Singing       |
+--| 4    | Elvis Q.     | Eating        |
+--| 5    | Daniel A.    | Eating        |
+--| 6    | Bob B.       | Horse Riding  |
+--+------+--------------+---------------+
+--
+--Activities table:
+--+------+--------------+
+--| id   | name         |
+--+------+--------------+
+--| 1    | Eating       |
+--| 2    | Singing      |
+--| 3    | Horse Riding |
+--+------+--------------+
+--
+--Result table:
+--+--------------+
+--| results      |
+--+--------------+
+--| Singing      |
+--+--------------+
+--
+--Eating activity is performed by 3 friends, maximum number of participants, (Jonathan D. , Elvis Q. and Daniel A.)
+--Horse Riding activity is performed by 1 friend, minimum number of participants, (Bob B.)
+--Singing is performed by 2 friends (Victor J. and Jade W.)
+
+--# Write your MySQL query statement below
+select activity from Friends group by activity
+having count(id) not in
+(
+select max(cnt) as cnt from
+    (select count(*) as cnt from Friends group by activity) as t1
+union
+select min(cnt) as cnt from
+    (select count(*) as cnt from Friends group by activity) as t2
+)
