Question

Data Science (EPH 2019-2020) to test end 02 Anterrupted Senaye Myers Activity Query Ashley's father keep track of the activities of Ashley and his friends in two tables FRIENDS and ACTIVITIES. Write a query to print the names of all the act um number of participants m with other mamm or Schema You are provided 2 tables FRIENDS. ACTIVITIES FRIENDS Name 1 Type Description D N TEGER The offrand This is the primary key NAME STRING The name of the friend ACTIVITY STRING Name of the activity which the friend take part in ACTIVITIES Type Description D NTEGER Dothecity NAME STRING Name of the activity Sample Data Tables Sample Input FRIENDS

MySQL

Answer 1

Tables:

mysql> select *from FRIENDS; ---- ---- ---+ | ID NAME ACTIVITY -- -- +- ----===-+- - -----+ 1 | James Smith Horse Riding | 2 | Enc Jenkins Eating 3 | Sean Cox | Eating | Horse Riding 5 Chris Evans Eating 6 | Jessica Breeds | Playing -- -+ 6 rows in set (0.00 sec) mysql> select *from Activities; | id Name +------+- 1 | Horse Riding | 2 | Eating 3 | Playing +------+---- 3 rows in set (0.00 sec)

Query:

select Activity from FRIENDS group by Activity having count(Activity) <> (select max(count) from (select count(*) as count from FRIENDS group by Activity) as s) and count(Activity) <> (select min(count) from (select count(*) as count from FRIENDS group by Activity) as s);

output:

mysql> select Activity from FRIENDS group by Activity having count(Activity) <> (select max(count) from (select count(*) as count from FRIENDS group by Activity) as s and count(Activity) > (select min(count) from (select count(*) as count from FRIENDS group by Activity) as s); | Activity | | Horse Riding | 1 row in set (0.00 sec)

Note: If you have any questions or queries comment below Thank you.