Question 23 30 points Save Answer The following diagram shows the relational schema of the database of The Red-White Athletic Club, which has many athletes playing in different sports. Each athlete plays one or many sports. Some athletes form teams, each coached by one coach Coaches_in coach_id date started sport_id Coach V coach id coach_name Sport sport_id sport_name who coaches in one or many sports. The primary key attributes are shown in bold below. Enter your answers to the text box and clearly label all the parts. Team team id sport_id coach id Plays_in athlete id team id date_joined Athlete athlete id athlete_name date_of_birth body weight a. Write a MySQL statement to create the table named COACHES_IN, using integer as the data type of all ID fields and date as the data type of date_started. b. Write a MySQL statement to add the data record of the athlete named "Adam Johnson" (with ID: 1234, birth date: 2001-03-14, and body weight: 160 lb.) to the table named "Athlete" (in which the data types are integer for athlete_id and body weight, string for athlete_name, and date for date_of_birth). c. Write a MySQL statement to display the total number of athletes in the team with ID 301. d. Write a MySQL statement to display the IDs and names of the athletes who do not play in any teams