Hmm, this looks like a classic elbow plot for determining the optimal number of clusters in k-means. I think I'll go with option B - 4 clusters seems like a reasonable choice based on the plot.
I think option C looks the most promising. Grouping by both dept_id and join_date seems like the right approach to get the sum of salaries for each department and join date.
Pete
8 months agoSkye
9 months agoGlenna
9 months agoMiesha
9 months agoBen
9 months agoGerald
9 months agoMerilyn
9 months agoSharan
9 months agoShayne
9 months agoDacia
9 months agoMelodie
9 months agoDorian
10 months agoLashonda
10 months ago