BUSI 3400 Lecture 9: Assignment 2
30 Dec 2016
School
Department
Course
Professor
Document Summary
List all team names of teams that currently have a manager. Where team. managernum is not null: list all players and their associated current team. Group by team. teamname, player. playername: list the names of all players who have played for more than five years with their current team. Where player. playernum=affiliation. playernum and affildateend is null and affilyrs >= 5. Group by player. playername: list the names and cities of all the teams with more than 2 current players. Order by team. teamcity: list all of the (cid:272)oa(cid:272)hes (cid:449)hose last (cid:374)a(cid:373)es (cid:271)egi(cid:374) (cid:449)ith (cid:858)a(cid:859) a(cid:374)d (cid:449)ho ha(cid:448)e had (cid:271)et(cid:449)ee(cid:374) (cid:1005)(cid:1004) a(cid:374)d (cid:1005)5 years of experience as a batting coach (see wexp_yrs, and wexp_type). And workexperience. wexp_yrs between 10 and 15: list the total number of years of experience of coach taylor with the expos. And team. teamname like "expos": list the number of different types of experience of coach taylor with the expos.
