Question Completion Status: Saved Question 23 30 points 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 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 Coaches in date_started coach id sport id Coach coach id coach name Sport Sport id sport name parts. Team team_id Sportid coach id Plays in athlete id team_id date Joined Athletes athlete Id athlete name date of birth body weight 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 > A # 3 * 2 $ 4 % 5 6 & 7 8 8 9 0 Q W E R T Y U 0 S D F Remaining Time: 52 minutes, 11 seconds. Question Completion Status: e_10 De are uate or DITT Douwergm 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). Write a MySQL statement to display the total number of athletes in the team with ID 301. Write a MySQL statement to display the IDs and names of the athletes who do not play in any teams. For the toolbar, press ALT+F30 (PC) or ALTFN+F10 (Mack BTU $ Paragraph Arini 14px 111 wee Select 1 WORDS POWERED BY TINY 19 od DO N # 3 $ 4 % 5 6 & 7 8 9 0 Q W E R. T