NHL NBA,MLB,NBA Salaries + Statistics (1876-2024)

player_id PLAYER ID	player_name PLAYER NAME	nickname NICKNAME	team_id TEAM ID	team_abbreviation TEAM ABBREVIATION	age AGE	gp GP	w W	l L	w_pct W PCT	min MIN	fgm FGM	fga FGA	fg_pct FG PCT	fg3m FG3M	fg3a FG3A	fg3_pct FG3 PCT	ftm FTM	fta FTA	ft_pct FT PCT	oreb OREB	dreb DREB	reb REB	ast AST	tov TOV	stl STL	blk BLK	blka BLKA	pf PF	pfd PFD	pts PTS	plus_minus PLUS MINUS	nba_fantasy_pts NBA FANTASY PTS	dd2 DD2	wnba_fantasy_pts WNBA FANTASY PTS	gp_rank GP RANK	w_rank W RANK	l_rank L RANK	w_pct_rank W PCT RANK	min_rank MIN RANK	fgm_rank FGM RANK	fga_rank FGA RANK	fg_pct_rank FG PCT RANK	fg3m_rank FG3M RANK	fg3a_rank FG3A RANK	fg3_pct_rank FG3 PCT RANK	ftm_rank FTM RANK	fta_rank FTA RANK	ft_pct_rank FT PCT RANK	oreb_rank OREB RANK	dreb_rank DREB RANK	reb_rank REB RANK	ast_rank AST RANK	tov_rank TOV RANK	stl_rank STL RANK	blk_rank BLK RANK	blka_rank BLKA RANK	pf_rank PF RANK	pfd_rank PFD RANK	pts_rank PTS RANK	plus_minus_rank PLUS MINUS RANK	nba_fantasy_pts_rank NBA FANTASY PTS RANK	dd2_rank DD2 RANK	td3_rank TD3 RANK	wnba_fantasy_pts_rank WNBA FANTASY PTS RANK	year YEAR
920	A.C. Green	A.C.	1610612742	DAL	34	82	20	62	0.244	32.3	3	6.5	0.453				1.4	2	0.716	2.7	5.5	8.1	1.5	0.8	1	0.3	0.4	1.9		7.3	-4.6	22.4	14	19.5	1	259	14	366	81	187	192	163	274	313	274	185	188	245	34	29	31	188	282	121	174	200	235	101	201	405	129	53	13	150	1997-98
243	Aaron McKie	Aaron	1610612755	PHI	25	81	34	47	0.42	22.4	1.7	4.7	0.365	0.1	0.8	0.19	0.5	0.7	0.764	0.7	2.1	2.9	2.2	0.9	1.2	0.2	0.4	2		4.1	0.3	14		12.1	52	169	55	299	190	280	251	379	200	177	250	344	356	170	233	205	215	143	261	61	278	187	213	183	290	164	229	207	13	244	1997-98
1425	Aaron Williams	Aaron	1610612760	SEA	26	65	49	16	0.754	11.6	1.8	3.4	0.525				1	1.3	0.776	0.8	1.5	2.3	0.2	0.8	0.3	0.6	0.4	1.8		4.6	1	9.5		8.8	202	55	319	30	327	275	308	34	274	354	274	250	274	152	227	282	258	397	296	356	97	213	248	143	277	125	303	207	13	304	1997-98
228	Adam Keefe	Adam	1610612762	UTA	28	80	61	19	0.763	25.6	2.9	5.3	0.54				2	2.5	0.81	2.2	3.2	5.5	1.1	0.9	0.7	0.3	0.7	2.2		7.8	5.4	18	5	16.2	73	6	293	24	161	192	229	20	274	366	274	132	141	95	65	110	87	237	270	219	185	94	190	95	186	21	180	100	13	190	1997-98
1502	Adonal Foyle	Adonal	1610612744	GSW	23	55	9	46	0.164	12	1.3	3.1	0.406				0.5	1.1	0.435	1.3	2	3.3	0.3	0.9	0.2	0.9	0.3	1.7		3	-3.1	10		9	264	354	63	410	324	325	318	312	274	345	274	350	294	408	143	216	185	386	267	377	57	233	262	121	336	369	296	207	13	301	1997-98
154	Adrian Caldwell	Adrian	1610612742	DAL	31	1	1		1	2.7																									435	422	435	1	435	434	438	434	274	366	274	421	425	421	429	435	438	427	434	423	400	417	437	197	435	192	438	207	13	439	1997-98
673	Alan Henderson	Alan	1610612737	ATL	25	69	42	27	0.609	29.1	5.3	10.9	0.485		0.1	0.5	3.7	5.6	0.652	2.9	3.5	6.4	1.1	1.6	0.6	0.5	1.1	2.5		14.3	1.3	25.3	12	24	182	94	200	137	118	73	87	88	237	286	4	44	28	313	22	94	66	243	132	241	110	17	122	150	70	111	109	61	13	103	1997-98
275	Allan Houston	Allan	1610612752	NYK	27	82	43	39	0.524	34.7	7	15.6	0.447	1	2.6	0.385	3.5	4.1	0.851	0.5	2.8	3.3	2.6	2.4	0.8	0.3	0.8	2.5		18.4	1.6	27	1	27.5	1	87	100	216	55	28	22	182	59	70	67	47	64	53	291	138	187	113	50	170	189	67	124	188	32	102	92	153	13	69	1997-98
947	Allen Iverson	Allen	1610612755	PHI	23	80	31	49	0.388	39.4	8.1	17.6	0.461	0.9	2.9	0.298	4.9	6.7	0.729	1.1	2.6	3.7	6.2	3.1	2.2	0.3	1.3	2.5		22	-1.2	40.2	12	37.8	73	188	51	312	11	9	10	139	72	51	194	18	14	220	174	149	159	17	17	6	181	7	126	197	9	290	14	61	13	11	1997-98
297	Alonzo Mourning	Alonzo	1610612748	MIA	28	58	39	19	0.672	33.4	7	12.6	0.551				5.3	8	0.665	3.3	6.3	9.6	0.9	3.1	0.7	2.2	1	3.6	0.1	19.3	7.4	37.9	24	35.7	240	118	293	96	69	27	56	15	274	366	274	11	6	305	10	21	16	266	16	201	9	28	12	5	25	6	20	26	13	21	1997-98


CREATE TABLE average_nba (
  "player_id" BIGINT,
  "player_name" VARCHAR,
  "nickname" VARCHAR,
  "team_id" BIGINT,
  "team_abbreviation" VARCHAR,
  "age" DOUBLE,
  "gp" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "w_pct" DOUBLE,
  "min" DOUBLE,
  "fgm" DOUBLE,
  "fga" DOUBLE,
  "fg_pct" DOUBLE,
  "fg3m" DOUBLE,
  "fg3a" DOUBLE,
  "fg3_pct" DOUBLE,
  "ftm" DOUBLE,
  "fta" DOUBLE,
  "ft_pct" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "reb" DOUBLE,
  "ast" DOUBLE,
  "tov" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "blka" DOUBLE,
  "pf" DOUBLE,
  "pfd" DOUBLE,
  "pts" DOUBLE,
  "plus_minus" DOUBLE,
  "nba_fantasy_pts" DOUBLE,
  "dd2" BIGINT,
  "td3" BIGINT,
  "wnba_fantasy_pts" DOUBLE,
  "gp_rank" BIGINT,
  "w_rank" BIGINT,
  "l_rank" BIGINT,
  "w_pct_rank" BIGINT,
  "min_rank" BIGINT,
  "fgm_rank" BIGINT,
  "fga_rank" BIGINT,
  "fg_pct_rank" BIGINT,
  "fg3m_rank" BIGINT,
  "fg3a_rank" BIGINT,
  "fg3_pct_rank" BIGINT,
  "ftm_rank" BIGINT,
  "fta_rank" BIGINT,
  "ft_pct_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "reb_rank" BIGINT,
  "ast_rank" BIGINT,
  "tov_rank" BIGINT,
  "stl_rank" BIGINT,
  "blk_rank" BIGINT,
  "blka_rank" BIGINT,
  "pf_rank" BIGINT,
  "pfd_rank" BIGINT,
  "pts_rank" BIGINT,
  "plus_minus_rank" BIGINT,
  "nba_fantasy_pts_rank" BIGINT,
  "dd2_rank" BIGINT,
  "td3_rank" BIGINT,
  "wnba_fantasy_pts_rank" BIGINT,
  "year" VARCHAR
);