Show all posts by user
Discussions about the Cornell men's and women's hockey teams
Re: Cornell @ Colgate 2.11.23 - 1 year ago
Colgate scores on a 4-on-4…. And we don’t get a guy back? Did the rules change?by BMac - Hockey
Re: Union @ Cornell - 1 year ago
If you can figure out the right way to do this with a window function, good on you. I spent a little time thinking about it and figured it was easier to just build progressive CTEs manually for each goal amount since we don’t need more than 12-15ish…. I’m sure it’s possible though. I’ve even done regressive sql before and felt like a golden godby BMac - Hockey
Re: Union @ Cornell - 1 year ago
I feel nerdsniped. Can I get the schema for the db? I think it’s something like: For each game order the CU goals by time and generate a row_number For each game, compute the shortest period between two goals by self-joining on row_number = row_number + 1 and subtracting the timestamps, then taking the min of the results. Do the same for 2, 3, 4, etc up to the max number of goals in aby BMac - Hockey
Re: Love Means Not Having to Say "You Just Suck": Cornell at Harvard - 1 year ago
THANK you I couldn’t find it anywhere!by BMac - Hockey
Re: Cornell @ Boston University, Jan. 14, 2023 - GAME TIME IS 4PM - 1 year ago
Lovely game in person until the last minute. Oof.by BMac - Hockey
Re: Andy Noel - 2 years ago
I for one nominate (as I do every year for alumni-elected trustee) Ben Scrivens.by BMac - Hockey
Re: Clarkson Game Thread - 2 years ago
I hate everything and everyone. How do you go from 4-0 to 4-4 in just over 5 minutes? This isn’t just officiating, they need to look in the mirror here. Let’s take this OT.by BMac - Hockey
Re: Red Hot game thread and watch - 2 years ago
Not a typo! It's really every other year as Red Hot Hockey, and on the intervening year it's called something else. Do you mean semi-annual vs. bi-annual? If so, I agree! It should be bi-annual!by BMac - Hockey
Winter sport seniors don’t get another year - 4 years ago
The NCAA has decided not to grant athletes from winter sports (including basketball) an extra year of eligibility due to coronavirus pandemic. Spring sport athletes were granted extra year.— Shams Charania (@ShamsCharania) March 30, 2020 Spring sport seniors can play next yearby BMac - Hockey
Re: Season's Over - 4 years ago
Ok ok “And for the 33rd time, the season ends in a win!” Doesn’t have the same ring.by BMac - Hockey
Season's Over - 4 years ago
And for the third time ever, we end the season on a win. (I thought we needed a new thread?)by BMac - Hockey
Re: 1969-70 memories - 4 years ago
Thanks for these. I didn’t know “good evening, hockey fans” wasn’t an ACM thing. I haven’t been to Lynah in ten years and thinking about that still gets me going.by BMac - Hockey
Re: Please take down that f@*#in COR 0 - PRV 4 tweet - 4 years ago
Love this idea! Sign me up coach.by BMac - Hockey
Re: An early look at 2019-2020 - 5 years ago
That’s crazy to think about. This team with a #1 seed. But also, those are a lot of results to flip. Any three individually, sure. But that many...by BMac - Hockey
Re: Cornell - Northeastern - 5 years ago
All I see is “Your event is about to begin. Please stand by”by BMac - Hockey
Re: ECAC Finals: Clarkson vs. Cornell - 5 years ago
Imafreshman is a Cornell fan, and a classy one. Congrats to Clarkson. This game sucked. Edit: the result sucked. Our guys were dominating and deserved the win.by BMac - Hockey
Re: ECAC Finals: Clarkson vs. Cornell - 5 years ago
That tying goal was magic. Let’s go!!!by BMac - Hockey
Re: ECAC QF Game 3: Union vs. Cornell (4:00 PM Start) - 5 years ago
Andyw why don’t you go ahead and make the game thread for the SF now, hmm?by BMac - Hockey
MSU series - 5 years ago
According to the twitter, if we had swept MSU we’d be 7 right now: Michigan State's sweep of Cornell is there as well. Big Red move up to 7 with two wins. Perhaps more interestingly, the rest of the Big Ten suffers a lot. OSU falls to 8. Notre and Penn State disappear from the bubble.— Joe Meloni (@JoeMeloni) March 4, 2019 ?s=20by BMac - Hockey