Instruction: Demonstrate how to perform a complex data transformation using dplyr, including filtering, selecting, and summarizing data.
Context: This question evaluates the candidate's proficiency with the dplyr package for data manipulation, an essential skill for efficient data analysis in R.