So I'm needing to reproduce the following data with the select statements in SQL

Batting Avg Leader select
Home Runs Leader Select
RBI Leader Select
OBP Leader Select
Hits Leader Select
Player Batting Stats BODY Select Has 16 columns with headers and proper calculations
Player Batting Stats - TOTAL select

Batting AVG

Shane VictorinoRF

.293

Home Runs

Ryan Howard1B

48

RBI

Ryan Howard1B

146

OBP

Chase Utley2B

.380

Hits

Chase Utley2B

177

Player Batting Stats - All Splits

NAME

Ryan Howard 1B

Chase Utley 2B

Shane Victorino RF

Jimmy Rollins SS

Pat Burrell LF

Pedro Feliz 3B

Jayson Werth LF

Carlos Ruiz C

Geoff Jenkins RF

Chris Coste C

Greg Dobbs 1B

Eric Bruntlett 3B

So Taguchi OF

Cole Hamels SP

Brett Myers SP

Jamie Moyer SP

Kyle Kendrick SP

Adam Eaton P

Matt Stairs 1B *

Joe Blanton RP *

Mike Cervenak 3B

Brad Harman 2B

Chad Durbin RP

Tadahito Iguchi 2B *

J.A. Happ SP

Greg Golson RF

T.J. Bohn OF

Lou Marson C

Chris Snelling LF

Clay Condrey RP

Ryan Madson RP

Andy Tracy 1B

R.J. Swindle RP

Les Walrond RP

Tom Gordon RP

Rudy Seanez RP

Drew Carpenter SP

J.C. Romero RP

Brad Lidge RP

Scott Eyre RP *

Total

GP	AB	R	H	2B	3B	HR	RBI	TB	BB	SO	SB	AVG	OBP	SLG	OPS
162	610	105	153	26	4	48	146	331	81	199	1	.251	.339	.543	.881
159	607	113	177	41	4	33	104	325	64	104	14	.292	.380	.535	.915
146	570	102	167	30	8	14	58	255	45	69	36	.293	.352	.447	.799
137	556	76	154	38	9	11	59	243	58	55	47	.277	.349	.437	.786
157	536	74	134	33	3	33	86	272	102	136	0	.250	.367	.507	.875
133	425	43	106	19	2	14	58	171	33	54	0	.249	.302	.402	.705
134	418	73	114	16	3	24	67	208	57	119	20	.273	.363	.498	.861
117	320	47	70	14	0	4	31	96	44	38	1	.219	.320	.300	.620
115	293	27	72	16	0	9	29	115	24	68	1	.246	.301	.392	.694
98	274	28	72	17	0	9	36	116	16	51	0	.263	.325	.423	.748
128	226	30	68	14	1	9	40	111	11	40	3	.301	.333	.491	.824
120	212	37	46	9	1	2	15	63	21	35	9	.217	.297	.297	.594
88	91	18	20	5	1	0	9	27	8	14	3	.220	.283	.297	.580
36	76	3	17	2	0	0	3	19	0	29	0	.224	.234	.250	.484
31	58	3	4	1	0	0	1	5	4	19	0	.069	.129	.086	.215
33	51	4	4	1	0	0	1	5	7	19	0	.078	.190	.098	.288
32	50	3	5	1	0	0	2	6	3	24	0	.100	.151	.120	.271
23	28	1	5	2	0	0	1	7	5	6	0	.179	.303	.250	.553
16	17	4	5	1	0	2	5	12	1	3	0	.294	.316	.706	1.022
13	16	0	1	0	0	0	1	1	0	10	0	.063	.059	.063	.121
10	13	0	2	0	0	0	1	2	0	5	0	.154	.154	.154	.308
6	10	1	1	1	0	0	1	2	1	1	0	.100	.182	.200	.382
71	9	0	1	0	0	0	0	1	0	3	0	.111	.111	.111	.222
4	7	0	2	1	0	0	0	3	0	0	0	.286	.286	.429	.714
8	7	0	0	0	0	0	0	0	0	4	0	.000	.000	.000	.000
6	6	2	0	0	0	0	0	0	0	4	1	.000	.000	.000	.000
14	5	1	2	1	0	0	3	3	0	1	0	.400	.400	.600	1.000
1	4	2	2	0	0	1	2	5	0	2	0	.500	.500	1.250	1.750
4	4	1	2	1	0	1	1	6	0	0	0	.500	.500	1.500	2.000
56	3	1	1	1	0	0	0	2	0	2	0	.333	.333	.667	1.000
76	2	0	0	0	0	0	0	0	0	2	0	.000	.000	.000	.000
4	2	0	0	0	0	0	1	0	1	1	0	.000	.250	.000	.250
3	2	0	0	0	0	0	1	0	0	0	0	.000	.000	.000	.000
6	1	0	0	0	0	0	0	0	0	0	0	.000	.000	.000	.000
34	0	0	0	0	0	0	0	0	0	0	0	.000	.000	.000	.000
42	0	0	0	0	0	0	0	0	0	0	0	.000	.000	.000	.000
1	0	0	0	0	0	0	0	0	0	0	0	.000	.000	.000	.000
81	0	0	0	0	0	0	0	0	0	0	0	.000	.000	.000	.000
72	0	0	0	0	0	0	0	0	0	0	0	.000	.000	.000	.000
19	0	0	0	0	0	0	0	0	0	0	0	.000	.000	.000	.000
162	5509	799	1407	291	36	214	762	2412	586	1117	136	.255	.332	.438	.770