Wake Forest’s Will Zalatoris forgoes final semester, turns pro

A second collegiate star has turned pro in the middle of the season, adding another name to the list of prospects who will be seeking sponsor exemptions once the PGA TOUR season resumes in January.

Wake Forest senior Will Zalatoris, the 2017 ACC Player of the Year, announced Thursday that he will turn pro and forego his final semester of collegiate golf.

“I wanted to give myself the best chance to have a TOUR card for 2018 and 2019,” Zalatoris told PGATOUR.COM. “I want to give myself the best opportunity to set myself up for the future, so I wanted to have these extra six months to play in a few more events and build my routine.”

Zalatoris finished his Wake Forest career with a 70.44 scoring average, breaking the school record of former FedExCup champ Bill Haas. Zalatoris won four collegiate titles, as well as the 2014 U.S. Junior Amateur.

His announcement came shortly after his Walker Cup teammate, Cameron Champ, made the leap to the pro ranks. Champ was in the middle of his senior season at Texas A&M.

This is believed to be the first time in recent history that two collegiate players of such high profile have turned pro in the middle of the same season.

“I think turning pro (in the middle of the season) will become a little bit more popular in the years to come, mainly because of the schedule,” Zalatoris said. “You get a full six months back of playing pro events. I was one of the kids who said, ‘You have four years of college and the rest of your life to play golf,’ but talking to some guys on TOUR, they mentioned how important that first year was.”

Champ finished T16 at last week’s Web.com Tour Q-School to secure status for the upcoming season. Zalatoris failed to advance out of second stage, so he will have to rely on sponsor exemptions and Monday qualifiers for starts on the PGA TOUR and Web.com Tour.

He has just 21 hours remaining toward his psychology degree, and is currently taking nine hours online. Being so close to completing his degree made it easier to leave school early, he said. He is planning to graduate in 2018.

Zalatoris isn’t the first U.S. Junior champion from Texas to turn pro after failing to advance out of Q-School’s second stage. Jordan Spieth took that path in 2013, winning that year’s John Deere Classic and qualifying for the TOUR Championship. Spieth and Zalatoris also share a swing coach, Cameron McCormick.

Turning pro early gives Zalatoris time to play both the PGA TOUR and Web.com Tour in his quest to earn a TOUR card.

The Wyndham Championship, the final PGA TOUR event before the FedExCup Playoffs and Web.com Tour Finals, is the only start he has confirmed on his schedule, he said.

Zalatoris is the third member of this year’s victorious U.S. Walker Cup team to turn pro, after Champ and Maverick McNealy. The U.S. defeated Great Britain & Ireland, 19-7, in September at Los Angeles Country Club.

Joaquin Niemann, the world’s top-ranked amateur, also is expected to turn pro in early 2018. Wyndham Clark, the 2017 Golfweek College Player of the Year, and Sam Burns, the 2017 Nicklaus Award winner, are other first-year pros who will be seeking TOUR starts in 2018. Both players earned full status at Web.com Tour Q-School.

McNealy, who graduated from Stanford with a degree in Management Science and Engineering, made his pro debut at the Safeway Open (T52). He also has sponsor exemptions into three PGA TOUR events in California (CareerBuilder Challenge, Farmers Insurance Open and AT&T Pebble Beach Pro-Am) and two in Texas (AT&T Byron Nelson, DEAN & DELUCA Invitational). He also has full Web.com Tour status for next year after finishing T10 at Q-School.

McNealy and Niemann are the past two winners of the Mark H. McCormack Medal, given to the world’s top-ranked amateur.

Spieth and Peter Uihlein are previous collegiate standouts to turn pro in December. Uihlein did so in 2011, forgoing his final semester at Oklahoma State to pursue starts on the European Tour.

Uihlein, the 2010 U.S. Amateur champion, won on that circuit in 2013 and is in the midst of his first season as a PGA TOUR member after winning the Nationwide Children’s Hospital Championship, the first event of this year’s Web.com Tour Finals. Uihlein, 28, is 40th in the current FedExCup standings.

Spieth turned pro in December 2012, halfway through his sophomore season at Texas.

The story behind Feinstein’s Ryder Cup book

The author was almost overwhelmed by the reception and cooperation he received in researching the book. Take his quest for a sit-down with Jordan Spieth, for example.

“The first thing that happened actually that was funny and tells you a lot about Jordan, he had to postpone twice for legit reasons, and when we sat down, the first thing he did was he apologized for postponing, and I said, Jordan, come on, you’re doing me a favor giving me this time, and he said, well, aren’t you doing me a favor putting me in your book?” Feinstein says.

“I’m like, really? Jordan needed to be in my book like I need to gain another 20 pounds. And so I laughed. And so then we sat and we talked for a long time, and at the end, like I said, I said, I’m going to need to circle back to you, and he said, yeah, yeah, let’s just make it simple, take my cell phone number and text me whenever you want to talk. You can’t ask for more than that.”

From Oct. 2 of last year, when the matches at Hazeltine ended in a hard-fought U.S. victory, to that Thanksgiving, Feinstein estimates he touched base with 16 or 17 of the players to get their take on the event, as well as Love and his European counterpart, Darren Clark. He also interviewed all of Love’s vice captains with the exception of Tiger Woods.

“But I had so much stuff from other guys on him, talking about how obsessed he became, and to me people always say, what was your biggest surprise,” Feinstein says. “My biggest surprise was definitely how into the whole thing Tiger became, especially given his past Ryder Cup participation when he was clearly just there because he thought he had to be.”

Even as he was in the midst of those follow-up interviews, Feinstein started writing some of the background and historical chapters the week after he got back from Minneapolis. The 320-page book was finished on Feb. 1 of this year.

“I’ve always said my newspaper training comes in because I can write fast and I can write on a deadline,” he noted. “I knew it was going to be a fast turnaround, but I was mentally ready to deal with it.”

While the competition is at the center of the book, the anecdotes Feinstein gleaned from the coaches and players are what sets it apart. Two of his favorites involve Clarke and Phil Mickelson, two long-time friends as well as keen competitors.

Clarke lost his first wife Heather to breast cancer shortly before the Ryder Cup matches in 2006. Mickelson’s wife Amy also has fought the disease, and among Clarke’s memories from that emotional year came at the opening ceremonies when members of the two teams walked in together.

“That year it was wife, player, player, wife, two from each side walking side by side, and Darren was supposed to walk in with Amy and Phil, and of course he did not have a partner,” Feinstein says. “And so when the music started and they were about to walk in, Amy walked around Phil, got in between Phil and Darren, took both their hands and walked in with them that way.

“And of course Darren never forget that, and Phil said that when Amy was diagnosed, the first phone call he got was from Darren saying, you know, I’m here for you.”

Another favorite story in Feinstein’s book came from Love, who remembers seeing Clarke and Mickelson deep in conversation into the wee hours on Sunday night after the U.S. victory.

“(He was) talking about sitting and watching Darren and Phil talking together at 2 or 3 in the morning and thinking, this is what Sam Ryder would have wanted the Ryder Cup to be, these guys who have been through so much more together than a golf match, coming back together after competing against one another for three days and sitting around and telling stories together,” Feinstein recalls.

10 People I Want To Play A Round Of Golf With – Beer Talk Inc.

This weeks list will cover the top ten people who I’d want to hit the links with for a round of golf. 10. Steph Curry- now hear me out on this one. As most of you know I hate the Warriors. I could use this opportunity to sabotage them. I could get into the loose cannons head and get him to hit me, or at least throw his mouth guard at me, and ultimately get him suspended. Therefore, he’s number 10.

9. Pre-Divorce Tiger Woods- one can only assume this would be a good time! Women everywhere, sinking birdies, and pounding beers? Yup, I’m in! Maybe his wife would’ve decided to assault him with a golf club that day and I could’ve witnessed it.

8. Stugotz- the man is hilarious. I hear he’s a pretty good golfer and he likes to have a good time as well. It would for sure be an unforgettable day getting to hang out with Stu.

7. Post-Divorce Pre-2017 Tiger Woods/DUI Tiger- I want to play golf with Tiger, okay? This version of him though I would have a chance of at least keeping up with him. He was a bogey machine during this period. Still would be playing with Tiger Woods though!

6. The guy whose made 80+ hole-in-ones- so this guy has to be the luckiest man alive, or the biggest liar alive, nonetheless, luck would be on my side golfing with him. Hell, I might even have a chance of making a hole-in-one.

5. Donald Trump- think of all the locker room talk we could have during a round of golf! It would be fantastic, the best round of golf ever played! Also, I’d be playing with the president of the United States, most likely on one of his own courses (free golf). It would be UGE!

For 2-4 I’m gonna lump together a group of 4 people. The math doesn’t quite add up but you’ll get the point.

2-4. Smylie Kaufman, Justin Thomas, Rickie Fowler, and Jordan Spieth- I want to go on their spring break trip to the Bahamas. For a week straight after the Masters they go partying/golfing in the Bahamas. This sounds like the most epic trip of all time. They run around the courses barefoot doing crazy stuff the whole time, I want to go bad! I’ll just need to remember to pack a ton of sunscreen. Side note: Smylie gets free Natty.

And finally, number 1

Kim Jong Un- this may be shocking to some, but I have good reason. For one thing he is able to control the weather. This means never playing in the rain again, also it means never playing in the scorching heat either. Secondly, his dad claimed he once shot a 38-under par, 34 at Pyongyang Golf Course. So one has to imagine he is a better golfer than his dad. Not only does Ol’ Rocket Man shoot bombs into the ocean, he probably shoots bombs down the fairway as well!

Disclaimer: John Daly did not make the list because I don’t know if I could hang for a whole round of golf with him.

There you have it, people. The list of who I would wave to play golf with the most!

-WileyP

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

Newsmaker of the Year: No. 4, Jordan Spieth

Dismissed because he’s supposedly too short off the tee, or not accurate enough with his irons, or just a streaky putter, Jordan Spieth is almost never the answer to the question of which top player, when he’s at his best, would win in a head-to-head match.

And yet here he is, at the age of 24, with 11 career wins and three majors, on a pace that compares favorably with the giants of the game. He might not possess the firepower of Dustin Johnson and Rory McIlroy, but since he burst onto the PGA Tour in 2013 he has all that matters – a better résumé.

Spieth took the next step in his development this year by becoming the Tour’s best iron player – and its most mentally tough.


Full list of 2017 Newsmakers of the Year


Just a great putter? Oh, puhleeze: He won three times despite putting statistics (42nd) that were his worst since his rookie year. Instead, he led the Tour in strokes gained-approach the green and this summer showed the discipline, golf IQ and bounce-back ability that makes him such a unique talent. 

Even with his putter misbehaving, Spieth closed out the Travelers Championship by holing a bunker shot in the playoff, then, in perhaps an even bigger surprise, perfectly executed the player-caddie celebration, chest-bumping caddie Michael Greller. A few weeks later, sublime iron play carried him into the lead at Royal Birkdale, his first in a major since his epic collapse at the 2016 Masters.

Once again his trusty putter betrayed him, and by the time he arrived on the 13th tee, he was tied with Matt Kuchar. What happened next was the stuff of legend – a lengthy ruling, gutsy up-and-down, stuffed tee shot and go-get-that putt – that lifted Spieth to his third major title.

Though he couldn’t complete the career Grand Slam at the PGA, he’ll likely have, oh, another two decades to join golf’s most exclusive club.

In the barroom debate of best vs. best, you can take the guys with the flair, with the booming tee shots and the sky-high irons. Spieth will just take the trophies.

THE MAJORS

Masters Tournament: Return to the 12th; faltering on Sunday (T-11)

Spieth pars 12, but makes quad on 15

Spieth takes another gut punch, but still standing

Article: Spieth splashes to worst Masters finish

**********

U.S. Open: 1 over usually good … not at Erin Hills (T-35)

**********

The Open: Unforgettable finish leads to major win No. 3 (1st)

Spieth survives confusing ordeal on 13

Photos: Spieth’s incredible journey on 13

Take it, it’s yours: Spieth gets claret jug

Chamblee: Spieth doesn’t have ‘it’ – ‘he has it all’

Article: Spieth silences his doubters – even himself

**********

PGA Championship: Career Grand Slam bid comes up well short (T-28)

Article: Spieth accepts that Grand Slam is off the table


TWO REGULAR TOUR WINS

AT&T Pebble Beach

Article: Spieth rising from ‘valley’ after Pebble Beach win

Travelers Championship

Spieith wins dramatic Travelers in playoff

Watch: Spieth holes bunker shot, goes nuts


FUN OUTSIDE OF TOUR LIFE

  • Watch: Spieth, Kaufman go fishing in Hawaii
  • Spieth officially unveils first signature shoe, Spieth One
  • Spieth talks about picking Brady’s brain
  • Spieth to be featured on Wheaties cereal box
  • #SB2K17: Spring break crew back on vacation
  • Palmer, Spieth experience draft with Saints
  • Spieth hanging with famous friends in Cabo
  • Spieth puts claret jug to good (and varied) use
  • Watch: Spieth throws first pitch at Wrigley Field
  • Spieth tees it up with Obama, Curry in Texas
  • Obama uses aliens, trash talk to beat Spieth

PHOTO GALLERIES

Photos: Jordan Spieth and Annie Verret

**********

Photos: Jordan Spieth through the years