There are two tables. The first table is 'RUN' and includes 'athleteID', 'RunID', 'RunDate', and 'RunTime'. The second table is 'Athlete' and includes 'AthleteID' and 'JoinDate' and 'Age'.
Write a query that shows the percentage of athletes who participated in the program in April 2024, meaning they have records in Table 1. An athlete may have multiple records in Table 1, but they are unique in Table 2.

Question

There are two tables. The first table is 'RUN' and includes 'athleteID', 'RunID', 'RunDate', and 'RunTime'.  The second table is 'Athlete' and includes 'AthleteID' and 'JoinDate' and 'Age'.
Write a query that shows the percentage of athletes who participated in the program in April 2024, meaning they have records in Table 1. An athlete may have multiple records in Table 1, but they are unique in Table 2.

NIKE

NIKE Interview Question

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches