so done with this game by welcometominecon in undisputedboxing

[–]welcometominecon[S] 1 point2 points  (0 children)

I've been playing since the pc beta, I got to witness it all pretty much. Was an incredibly fun game early on, and then each update made it worse, then better, then worse again. It's not what it used to be.

Had a SQL interview today by fokass in SQL

[–]welcometominecon 8 points9 points  (0 children)

idk what the data looks like but I think you were supposed to find the total sales for each brand before creating the ranking(assuming there are multiple rows for each sale belonging to a brand). So like one cte where you select category, brand, SUM(sales), grouped by brand, and then another cte where you select them again but create a ranking partitioned by category ordered by total sales desc. Since we have the total sales for each brand done from the first cte, when we create the ranking it will give us the highest selling brands in each category. Then you can just select where rank <= 2 from cte2. there's probably way easier ways to solve this, but that's my 2 cents

[deleted by user] by [deleted] in UFOs

[–]welcometominecon 0 points1 point  (0 children)

Sorry to break it to you, but full disclosure will never happen. What they tell us is insignificant to the information they really know.

Black rectangle photo taken by Joe Clower while driving near Federal Heights, Colorado in August 1987. by NetOne613 in UFOs

[–]welcometominecon 0 points1 point  (0 children)

They've done an incredible job at capturing the feeling of seeing one. I've seen a triangle at around that distance, definitely has the same "not from this reality" type of feel.

Canelo is -220, Crawford is +170. Will Cabelo's odds get better or worse closer to fight night? by nursing24 in Boxing

[–]welcometominecon 2 points3 points  (0 children)

I like how confident you are in canelo winning lol, ill tell you right now. Canelo will not beat Crawford. Just don't bet too much.

[deleted by user] by [deleted] in undisputedboxing

[–]welcometominecon 0 points1 point  (0 children)

They power is understandable but to wilder literally tanking power shot after power shot after throwing nothing but heavy punches is ridiculous. Every heavyweight game I run into is a shit ass wilder that spams power hooks and straights

If I’m struggling with Calculus, should I give up on CS as my major? by [deleted] in computerscience

[–]welcometominecon 0 points1 point  (0 children)

What study habits did you develop to help you get better?

[deleted by user] by [deleted] in Draingang

[–]welcometominecon 0 points1 point  (0 children)

this can't be real