I have the following mysql table named “schedule”:
1 | dan | Monday
2 | ken | Monday
3 | josh | Tuesday
4 | karin | Wednesday
5 | dana | Thursday
6 | ruby | Tuesday
7 | linda | Thursday
there is one weekday that only 1 person is schedule to (“Wednesday”).
the rest have more than 1 person for weekday.
what sql query should I use to get that row?