The History Of Baseball

player_id Player Id	year Year	team_id Team Id	league_id League Id	inseason Inseason	half Half	g G	w W	l L	rank Rank
hanlone01	1892	BLN	NL	3	1	56	17	39	12
hanlone01	1892	BLN	NL	3	2	77	26	46	10
vanhage01	1892	BLN	NL	1	1	11	1	10	12
waltzjo99	1892	BLN	NL	2	1	8	2	6	12
wardjo01	1892	BRO	NL	1	1	78	51	26	2
wardjo01	1892	BRO	NL	1	2	80	44	33	3
seleefr99	1892	BSN	NL	1	1	75	52	22	1
seleefr99	1892	BSN	NL	1	2	77	50	26	2
ansonca01	1892	CHN	NL	1	1	71	31	39	8
ansonca01	1892	CHN	NL	1	2	76	39	37	7


CREATE TABLE manager_half (
  "player_id" VARCHAR,
  "year" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "inseason" BIGINT,
  "half" BIGINT,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "rank" BIGINT
);