List the results alphabetically by team name. b. List all of the coaches whose last names begin

Question:

List the results alphabetically by team name.

b. List all of the coaches whose last names begin with

‘‘D’’ and who have between 5 and 10 years of experience as college coaches (see YEARSEXPERIENCE and EXPERIENCETYPE).

c. Find the total number of years of experience of Coach Taylor on team number 23.

d. Find the number of different types of experience that Coach Taylor on team number 23 has.

e. Find the total number of years of experience of each coach on team number 23.

f. How many different manufacturers make bats for the league’s teams?

g. Assume that team names are unique. Find the names of the players who have played for the Dodgers for at least five years (see YEARS in the AFFILIATION Table.)

h. Assume that team names are unique. Find the total number of years of work experience of each coach on the Dodgers, but include in the result only those coaches who have more than eight years of experience.

i. Find the names of the league’s youngest players.

j. Find the names of the league’s youngest players whose last names begin with the letter ‘‘B’’.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: