You are working with a Fun Run database that includes the fo…
You are working with a Fun Run database that includes the following tables: Participants ParticipantID Name Age Gender TeamID 1 Sarah Johnson 25 F 101 2 Mark Smith 30 M 102 3 Emily Davis 22 F 101 4 John Anderson 35 M 103 5 Lisa White 28 F 102 Teams TeamID TeamName CoachName 101 Speed Racers Coach Allen 102 Fast & Furious Coach Baker 103 Lightning Bolts Coach Carter Results ParticipantID FinishTime DistanceCompleted 1 32.25 5K 2 32.45 5K 3 29.10 5K 4 45.30 10K 5 31.30 5K Complete the following SQL query with the correct syntax and logic to find all participants who finished the 5K race with a faster time than the average finish time for the 5K race SELECT Name, FinishTimeFROM Participants P JOIN Results R ON P.ParticipantID = R.ParticipantID WHERE R.DistanceCompleted = ‘5K’ AND R.FinishTime < ______________________;
Read Details