No. 15: Tony Finau

INSIGHTS FROM THE INSIDERS

PGATOUR.COM’s Insiders offer their expert views on what to expect from Tony Finau in 2018.

TOUR INSIDER by Cameron Morfit

One of the most explosive players on the planet, Finau led the TOUR in driving distance going into the six-week break, averaging 336.6 yards off the tee. That’s hardly surprising. He led the TOUR with 50 rounds in the 60s last season, and showed his mettle with a clutch, final-round 64 at the BMW Championship (T7), ensuring he would move on to the season-ending TOUR Championship at East Lake (T7). He finished 19th in the FedExCup, and started his 2017-2018 season with a runner-up at the Safeway Open, suggesting another win isn’t far away.    

Click here to follow Cameron on Twitter

FANTASY INSIDER by Rob Bolton

He’s everything we want and he’s already off to a flying start at ninth in the FedExCup standings. The 28-year-old, father of four, averaged nearly 30 starts in his first three seasons on the PGA TOUR, so he doesn’t mind hitting the road. Even better, he survived the cut in nearly three-quarters of them. Because he checks all of the boxes to produce in PGA TOUR Fantasy Golf presented by SERVPRO and has natural athletic ability, he comps to Dustin Johnson analytically and physically. The wins should come in bunches for Finau, but even if they don’t, we’ll continue to embrace what we already accept him to be: a force.

Click here to follow Rob on Twitter

EQUIPMENT INSIDER by Jonathan Wall

The former Nike equipment staffer recorded his best season on TOUR without an equipment contract. A majority of his setup is comprised of PING equipment, including a G400 3-wood and larger-profile i200 3-iron. Finau remains one of the few players using a custom Piretti putter — the same brand Henrik Stenson had in the bag when he won the season-long FedExCup title in 2013. Continues to play Titleist Pro V1x without a golf ball contract. 

Click here to follow Jonathan on Twitter

STYLE INSIDER by Greg Monteforte

Finau’s athletic build and explosive game are perfect fits for Nike’s sporty threads. The trim fit of his trousers is something all golfers should copy. Look for Finau to continue to bring many of the modern athleisure and streetwear looks to the course in 2018.

Click here to follow Greg on Twitter

Rank Function – Examples using Golf Scores. – Not the DBA

Jordan Spieth won the 2017 British Open with a total round score of 289. Behind him in the scoring there were several ties.

I have created a table which shows the scores for each player who made the cut. The table is already in pivot form. Here is the definition ( DDL)

CREATE TABLE dbo.British_Open_Golf_2017_results
(
Player varchar(50) NOT NULL ,
Country varchar(3) NOT NULL ,
R1_Score smallint NOT NULL,
R2_Score smallint NOT NULL,
R3_Score smallint NOT NULL,
R4_Score smallint NOT NULL,
Total_Score AS R1_Score + R2_Score + R3_Score + R4_Score,
Prize_Money money NOT NULL
)
;

The script below populates the table.


Insert British_Open_Golf_2017_results
(
Player		,
Country		,
R1_Score	,
R2_Score	,
R3_Score	,
R4_Score	,
Prize_Money
)
VALUES
('Jordan Spieth','USA',65,69,65,69,1845000.00),
('Matt Kuchar','USA',65,71,66,69,1067000.00),
('Li Haotong','CHN',69,73,69,63,684000.00),
('Rafael Cabrera-Bello','SPN',67,73,67,68,480000.00),
('Rory McIlroy','NIR',71,68,69,67,480000.00),
('Marc Leishman','AU',69,76,66,65,281000.00),
('Alex Noren','SWE',68,72,69,67,281000.00),
('Branden Grace','ZAF',70,74,62,70,281000.00),
('Matthew Southgate','GBR',72,72,67,65,281000.00),
('Brooks Koepka','USA',65,72,68,71,281000.00),
('Henrik Stenson','SWE',69,73,65,70,175333.00),
('Paul Casey','GBR',66,77,67,67,175333.00),
('Chan Kim','USA',72,68,67,70,175333.00),
('Chris Wood','GBR',71,72,68,67,128917.00),
('Zach Johnson','USA',75,66,71,66,128917.00),
('Ian Poulter','GBR',67,70,71,70,128917.00),
('Jason Dufner','USA',73,71,66,68,128917.00),
('Hideki Matsuyama','JPN',68,72,66,72,128917.00),
('Austin Connelly','CA',67,72,66,73,128917.00),
('Charley Hoffman','USA',67,73,72,67,104500.00),
('Xander Schauffele','US',69,75,70,65,104500.00),
('Adam Scott','AUS',69,74,70,67,88000.00),
('Jamie Lovemark','USA',71,69,70,70,88000.00),
('Richie Ramsay','SCT',68,70,70,72,88000.00),
('Rickie Fowler','USA',71,71,67,71,88000.00),
('Richard Bland','GBR',67,72,70,71,88000.00),
('Lee Westwood','GBR',71,74,69,67,64500.00),
('Aaron Baddeley','USA',69,76,72,64,64500.00),
('David Drysdale','GBR',72,73,66,70,64500.00),
('Thongchai Jaidee','THA',70,73,68,70,64500.00),
('Bubba Watson','USA',68,72,71,70,64500.00),
('Jason Day','AUS',69,76,65,71,64500.00),
('Tony Finau','USA',70,73,67,71,64500.00),
('Tommy Fleetwood','GBR',76,69,66,70,64500.00),
('Andrew Johnston','GBR',69,74,67,71,64500.00),
('Daniel Berger','USA',68,76,70,67,64500.00),
('Steve Stricker','USA',70,72,69,71,45286.00),
('Sergio Garcia','ESP',73,69,68,72,45286.00),
('Soren Kjeldsen','DNK',71,71,72,68,45286.00),
('Martin Kaymer','GER',72,72,70,68,45286.00),
('Webb Simpson','USA',71,74,70,67,45286.00),
('Russell Henley','USA',70,70,75,67,45286.00),
('Laurie Canter','ENG',70,72,72,68,45286.00),
('Kevin Na','KOR',68,75,68,72,31070.00),
('Ross Fisher','GBR',70,72,66,75,31070.00),
('Sung Kang','KR',68,73,76,66,31070.00),
('Joost Luiten','NLD',68,72,70,73,31070.00),
('Andrew Dodt','AUS',69,75,69,70,31070.00),
('Peter Uihlein','US',72,72,69,70,31070.00),
('Thomas Pieters','ITA',69,75,68,71,31070.00),
('Matthew Fitzpatrick','GBR',69,73,68,73,31070.00),
('Yikeun Chang','KR',71,71,71,70,31070.00),
('Jon Rahm','ES',69,74,70,70,31070.00),
('Justin Rose','GBR',71,74,69,70,25843.00),
('Scott Hend','AUS',71,74,65,74,25843.00),
('Jimmy Walker','USA',72,72,70,70,25843.00),
('J.B. Holmes','USA',71,72,71,70,25843.00),
('Kevin Kisner','USA',70,71,74,69,25843.00),
('Dustin Johnson','USA',71,72,64,77,25843.00),
('Toby Tree','',70,75,69,70,25843.00),
('Ernie Els','ZAF',68,73,70,74,25000.00),
('Sean OHair','USA',72,73,71,70,24500.00),
('Shaun Norris','ZAF',71,74,65,76,24500.00),
('Charl Schwartzel','ZAF',66,78,71,71,24500.00),
('K.T. Kim','KR',73,71,69,73,24500.00),
('Mike Lorenzo-vera','FR',75,70,70,71,24500.00),
('Thorbjorn Olesen','DNK',70,72,74,70,24500.00),
('Younghan Song','KR',71,74,69,72,24500.00),
('Alfie Plant','GBR',71,73,69,73,24500.00),
('Gary Woodland','USA',70,69,74,74,23556.00),
('Brandon Stone','ZAF',73,72,68,74,23556.00),
('Andy Sullivan','GBR',70,75,69,73,23556.00)
;

Running the sql which follows allows us to see the final leader board


SELECT
	Player		,
	Country		,
	Total_Score
FROM
	dbo.British_Open_Golf_2017_results
ORDER BY
	Total_Score ASC
;

and confirms that the bold Spieth won the tournament,

Player Country Total_Score
Jordan Spieth USA 268
Matt Kuchar USA 271
Li Haotong CHN 274
Rafael Cabrera-Bello SPN 275
Rory McIlroy NIR 275
Marc Leishman AU 276
Alex Noren SWE 276
Branden Grace ZAF 276
Matthew Southgate GBR 276
Brooks Koepka USA 276
Henrik Stenson SWE 277
Paul Casey GBR 277
Chan Kim USA 277
Chris Wood GBR 278
Zach Johnson USA 278
Ian Poulter GBR 278
Jason Dufner USA 278
Hideki Matsuyama JPN 278
Austin Connelly CA 278
Charley Hoffman USA 279
Xander Schauffele US 279
Adam Scott AUS 280
Jamie Lovemark USA 280
Richie Ramsay SCT 280
Rickie Fowler USA 280
Richard Bland GBR 280
Lee Westwood GBR 281
Aaron Baddeley USA 281
David Drysdale GBR 281
Thongchai Jaidee THA 281
Bubba Watson USA 281
Jason Day AUS 281
Tony Finau USA 281
Tommy Fleetwood GBR 281
Andrew Johnston GBR 281
Daniel Berger USA 281
Steve Stricker USA 282
Sergio Garcia ESP 282
Soren Kjeldsen DNK 282
Martin Kaymer GER 282
Webb Simpson USA 282
Russell Henley USA 282
Laurie Canter ENG 282
Kevin Na KOR 283
Ross Fisher GBR 283
Sung Kang KR 283
Joost Luiten NLD 283
Andrew Dodt AUS 283
Peter Uihlein US 283
Thomas Pieters ITA 283
Matthew Fitzpatrick GBR 283
Yikeun Chang KR 283
Jon Rahm ES 283
Justin Rose GBR 284
Scott Hend AUS 284
Jimmy Walker USA 284
J.B. Holmes USA 284
Kevin Kisner USA 284
Dustin Johnson USA 284
Toby Tree 284
Ernie Els ZAF 285
Sean OHair USA 286
Shaun Norris ZAF 286
Charl Schwartzel ZAF 286
K.T. Kim KR 286
Mike Lorenzo-vera FR 286
Thorbjorn Olesen DNK 286
Younghan Song KR 286
Alfie Plant GBR 286
Gary Woodland USA 287
Brandon Stone ZAF 287
Andy Sullivan GBR 287

In order to divide the prize money up, the tournament organisers have to take into account the frequently occurring scenario which sees two or more players end on the same final score.  There were two players on 275 and five players on 276.  Where players are tied, they must receive the same prize money. The RANK function allows us to do this easily.


SELECT
	Player		,
	Country		,
	Total_Score	,
	Prize_Money ,
	Rank() OVER (ORDER BY Total_Score ASC) as Total_Score_Rank

FROM
 	 dbo.British_Open_Golf_2017_results
;

Player	Country	Total_Score	Prize_Money	Total_Score_Rank
Jordan Spieth	USA	268	1845000.00	1
Matt Kuchar	USA	271	1067000.00	2
Li Haotong	CHN	274	684000.00	3
Rafael Cabrera-Bello	SPN	275	480000.00	4
Rory McIlroy	NIR	275	480000.00	4
Marc Leishman	AU	276	281000.00	6
Alex Noren	SWE	276	281000.00	6
Branden Grace	ZAF	276	281000.00	6
Matthew Southgate	GBR	276	281000.00	6
Brooks Koepka	USA	276	281000.00	6
Henrik Stenson	SWE	277	175333.00	11
Paul Casey	GBR	277	175333.00	11
Chan Kim	USA	277	175333.00	11
Chris Wood	GBR	278	128917.00	14
Zach Johnson	USA	278	128917.00	14
Ian Poulter	GBR	278	128917.00	14
Jason Dufner	USA	278	128917.00	14
Hideki Matsuyama	JPN	278	128917.00	14
Austin Connelly	CA	278	128917.00	14
Charley Hoffman	USA	279	104500.00	20
Xander Schauffele	US	279	104500.00	20
Adam Scott	AUS	280	88000.00	22
Jamie Lovemark	USA	280	88000.00	22
Richie Ramsay	SCT	280	88000.00	22
Rickie Fowler	USA	280	88000.00	22
Richard Bland	GBR	280	88000.00	22
Lee Westwood	GBR	281	64500.00	27
Aaron Baddeley	USA	281	64500.00	27
David Drysdale	GBR	281	64500.00	27
Thongchai Jaidee	THA	281	64500.00	27
Bubba Watson	USA	281	64500.00	27
Jason Day	AUS	281	64500.00	27
Tony Finau	USA	281	64500.00	27
Tommy Fleetwood	GBR	281	64500.00	27
Andrew Johnston	GBR	281	64500.00	27
Daniel Berger	USA	281	64500.00	27
Steve Stricker	USA	282	45286.00	37
Sergio Garcia	ESP	282	45286.00	37
Soren Kjeldsen	DNK	282	45286.00	37
Martin Kaymer	GER	282	45286.00	37
Webb Simpson	USA	282	45286.00	37
Russell Henley	USA	282	45286.00	37
Laurie Canter	ENG	282	45286.00	37
Kevin Na	KOR	283	31070.00	44
Ross Fisher	GBR	283	31070.00	44
Sung Kang	KR	283	31070.00	44
Joost Luiten	NLD	283	31070.00	44
Andrew Dodt	AUS	283	31070.00	44
Peter Uihlein	US	283	31070.00	44
Thomas Pieters	ITA	283	31070.00	44
Matthew Fitzpatrick	GBR	283	31070.00	44
Yikeun Chang	KR	283	31070.00	44
Jon Rahm	ES	283	31070.00	44
Justin Rose	GBR	284	25843.00	54
Scott Hend	AUS	284	25843.00	54
Jimmy Walker	USA	284	25843.00	54
J.B. Holmes	USA	284	25843.00	54
Kevin Kisner	USA	284	25843.00	54
Dustin Johnson	USA	284	25843.00	54
Toby Tree		284	25843.00	54
Ernie Els	ZAF	285	25000.00	61
Sean OHair	USA	286	24500.00	62
Shaun Norris	ZAF	286	24500.00	62
Charl Schwartzel	ZAF	286	24500.00	62
K.T. Kim	KR	286	24500.00	62
Mike Lorenzo-vera	FR	286	24500.00	62
Thorbjorn Olesen	DNK	286	24500.00	62
Younghan Song	KR	286	24500.00	62
Alfie Plant	GBR	286	24500.00	62
Gary Woodland	USA	287	23556.00	70
Brandon Stone	ZAF	287	23556.00	70
Andy Sullivan	GBR	287	23556.00	70

Two players, Mc.Ilroy and Cabrero-Bell tied for fourth place, and were awarded the same prize money ( 480,000 dollars ).  Scrolling down the list, you can see several other score ties, as the calculated rank shows.

Whilst we are looking at this function, let’s go a little further and rank the players within their country.

SELECT
	Player		,
	Country		,
	Total_Score	,
	Prize_Money ,
	Rank() OVER (Partition BY Country ORDER BY Total_Score ASC) as Total_Score_Rank

FROM
 	 dbo.British_Open_Golf_2017_results 

Player	Country	Total_Score	Prize_Money	Total_Score_Rank
Toby Tree		284	25843.00	1
Marc Leishman	AU	276	281000.00	1
Adam Scott	AUS	280	88000.00	1
Jason Day	AUS	281	64500.00	2
Andrew Dodt	AUS	283	31070.00	3
Scott Hend	AUS	284	25843.00	4
Austin Connelly	CA	278	128917.00	1
Li Haotong	CHN	274	684000.00	1
Soren Kjeldsen	DNK	282	45286.00	1
Thorbjorn Olesen	DNK	286	24500.00	2
Laurie Canter	ENG	282	45286.00	1
Jon Rahm	ES	283	31070.00	1
Sergio Garcia	ESP	282	45286.00	1
Mike Lorenzo-vera	FR	286	24500.00	1
Matthew Southgate	GBR	276	281000.00	1
Paul Casey	GBR	277	175333.00	2
Chris Wood	GBR	278	128917.00	3
Ian Poulter	GBR	278	128917.00	3
Richard Bland	GBR	280	88000.00	5
Lee Westwood	GBR	281	64500.00	6
David Drysdale	GBR	281	64500.00	6
Tommy Fleetwood	GBR	281	64500.00	6
Andrew Johnston	GBR	281	64500.00	6
Matthew Fitzpatrick	GBR	283	31070.00	10
Ross Fisher	GBR	283	31070.00	10
Justin Rose	GBR	284	25843.00	12
Alfie Plant	GBR	286	24500.00	13
Andy Sullivan	GBR	287	23556.00	14
Martin Kaymer	GER	282	45286.00	1
Thomas Pieters	ITA	283	31070.00	1
Hideki Matsuyama	JPN	278	128917.00	1
Kevin Na	KOR	283	31070.00	1
Yikeun Chang	KR	283	31070.00	1
Sung Kang	KR	283	31070.00	1
Younghan Song	KR	286	24500.00	3
K.T. Kim	KR	286	24500.00	3
Rory McIlroy	NIR	275	480000.00	1
Joost Luiten	NLD	283	31070.00	1
Richie Ramsay	SCT	280	88000.00	1
Rafael Cabrera-Bello	SPN	275	480000.00	1
Alex Noren	SWE	276	281000.00	1
Henrik Stenson	SWE	277	175333.00	2
Thongchai Jaidee	THA	281	64500.00	1
Xander Schauffele	US	279	104500.00	1
Peter Uihlein	US	283	31070.00	2
Jordan Spieth	USA	268	1845000.00	1
Matt Kuchar	USA	271	1067000.00	2
Brooks Koepka	USA	276	281000.00	3
Chan Kim	USA	277	175333.00	4
Jason Dufner	USA	278	128917.00	5
Zach Johnson	USA	278	128917.00	5
Charley Hoffman	USA	279	104500.00	7
Rickie Fowler	USA	280	88000.00	8
Jamie Lovemark	USA	280	88000.00	8
Bubba Watson	USA	281	64500.00	10
Aaron Baddeley	USA	281	64500.00	10
Daniel Berger	USA	281	64500.00	10
Tony Finau	USA	281	64500.00	10
Webb Simpson	USA	282	45286.00	14
Russell Henley	USA	282	45286.00	14
Steve Stricker	USA	282	45286.00	14
Jimmy Walker	USA	284	25843.00	17
J.B. Holmes	USA	284	25843.00	17
Kevin Kisner	USA	284	25843.00	17
Dustin Johnson	USA	284	25843.00	17
Sean OHair	USA	286	24500.00	21
Gary Woodland	USA	287	23556.00	22
Branden Grace	ZAF	276	281000.00	1
Ernie Els	ZAF	285	25000.00	2
Shaun Norris	ZAF	286	24500.00	3
Charl Schwartzel	ZAF	286	24500.00	3
Brandon Stone	ZAF	287	23556.00	5

We see that Matthew Southgate was the best performing GBR player. Rory McIlroy finished on a better score, but he is listed as a ‘NIR’ ( Northern Ireland ) player. The brilliantly named Toby Tree did not have a country assignation, hence no value against him in the country column.

Note the effect of the partition on the rank. Each time a new country is encountered in the, the rank value is reset to 1.

https://docs.microsoft.com/en-us/sql/t-sql/functions/rank-transact-sql

https://docs.microsoft.com/en-us/sql/t-sql/functions/dense-rank-transact-sql

https://docs.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql

Thanks for reading!

David J Lacey 13 Dec 2017

QBE Shoot Out ~ Final Round



2017 PGA QBE Shoot Out ~ Final Round

Tiger Woods, Dustin Johnson, Jordan Spieth, Justin Thomas, Jon Rahm, Hideki Matsuyama, Justin Rose, Brooks Koepka, Henrik Stenson, Rickie Fowler, Rory Mcilroy, Sergio Garcia, Jason Day, Marc Leishman, Paul Casey, Matt Kuchar, Alex Noren, Tommy Fleetwood, Pat Perez, Rafa Cabrera-Bello, Francesco Molinari, Louie Oosthuizen, Patrick Reed, Schauffele, Kevin Kisner, Butch Harman, Charlie Hoffman, Matthew Fitzpatrick, Brandon Grace, Adam Scott, Kevin Chappell, Charles Schwartzel, Ross Fisher, Phil Mickelson, Thomas Pieters, Y. Ikeda, Jason Dufner, B. Weisberger, Si Woo Kim, Tony Finau, Patrick Cantlay, Johnny Vegas, Brendan Steele, Webb Simpson, Zach Johnson, B. Snedeker, Gary Woodland, Ian Poulter, Bill Haas, Ryan Moore, Peter Uihlein, Adam hadwin, Li Haotong, Shane Lowry, Aphibarnrat, Walker, J.Suri, Lee Westwood, A. Lahiri, Billy Horschel, Martin Kaymer, Russell Knox, J.B Holmes, Bubba Watson, Cameron Smith, Chris Wood, Bryson Dechambeau, Danny Willett

QBE Shoot Out ~ Round 2 | Back 9



2017 PGA QBE Shoot Out ~ Round 2 ~ Back 9

Tiger Woods, Dustin Johnson, Jordan Spieth, Justin Thomas, Jon Rahm, Hideki Matsuyama, Justin Rose, Brooks Koepka, Henrik Stenson, Rickie Fowler, Rory Mcilroy, Sergio Garcia, Jason Day, Marc Leishman, Paul Casey, Matt Kuchar, Alex Noren, Tommy Fleetwood, Pat Perez, Rafa Cabrera-Bello, Francesco Molinari, Louie Oosthuizen, Patrick Reed, Schauffele, Kevin Kisner, Butch Harman, Charlie Hoffman, Matthew Fitzpatrick, Brandon Grace, Adam Scott, Kevin Chappell, Charles Schwartzel, Ross Fisher, Phil Mickelson, Thomas Pieters, Y. Ikeda, Jason Dufner, B. Weisberger, Si Woo Kim, Tony Finau, Patrick Cantlay, Johnny Vegas, Brendan Steele, Webb Simpson, Zach Johnson, B. Snedeker, Gary Woodland, Ian Poulter, Bill Haas, Ryan Moore, Peter Uihlein, Adam hadwin, Li Haotong, Shane Lowry, Aphibarnrat, Walker, J.Suri, Lee Westwood, A. Lahiri, Billy Horschel, Martin Kaymer, Russell Knox, J.B Holmes, Bubba Watson, Cameron Smith, Chris Wood, Bryson Dechambeau, Danny Willett

QBE Shoot Out ~ Round 2 | Front 9



2017 PGA QBE Shoot Out ~ Round 2 ~ Front 9

Tiger Woods, Dustin Johnson, Jordan Spieth, Justin Thomas, Jon Rahm, Hideki Matsuyama, Justin Rose, Brooks Koepka, Henrik Stenson, Rickie Fowler, Rory Mcilroy, Sergio Garcia, Jason Day, Marc Leishman, Paul Casey, Matt Kuchar, Alex Noren, Tommy Fleetwood, Pat Perez, Rafa Cabrera-Bello, Francesco Molinari, Louie Oosthuizen, Patrick Reed, Schauffele, Kevin Kisner, Butch Harman, Charlie Hoffman, Matthew Fitzpatrick, Brandon Grace, Adam Scott, Kevin Chappell, Charles Schwartzel, Ross Fisher, Phil Mickelson, Thomas Pieters, Y. Ikeda, Jason Dufner, B. Weisberger, Si Woo Kim, Tony Finau, Patrick Cantlay, Johnny Vegas, Brendan Steele, Webb Simpson, Zach Johnson, B. Snedeker, Gary Woodland, Ian Poulter, Bill Haas, Ryan Moore, Peter Uihlein, Adam hadwin, Li Haotong, Shane Lowry, Aphibarnrat, Walker, J.Suri, Lee Westwood, A. Lahiri, Billy Horschel, Martin Kaymer, Russell Knox, J.B Holmes, Bubba Watson, Cameron Smith, Chris Wood, Bryson Dechambeau, Danny Willett