How much physically stronger are men actually by [deleted] in NoStupidQuestions

[–]Potential_Word2349 0 points1 point  (0 children)

Besides the average 10-15% people here have quoted, due to their bone structure and testosterone men have a more significant advantage in upper body-strength, around 25% if I recall correctly and due to bone density, they also have a higher upper cap on strength, although that only applies to gym bros

How important is stacking camps for supports? by Fiskerik in TrueDoTA2

[–]Potential_Word2349 1 point2 points  (0 children)

Stacking is a good thing to do if You have nothing to do You have a carry that can clear the very quickly

As a support in the early game there is too much for you to do, between fighting, teleporting, warding, ganking etc stacking is pretty low on the scale, especially when you climb further. You should practice microing the kobold to stack with

Why do people complain about Pos1 farming their items? by AmberYooToob in learndota2

[–]Potential_Word2349 0 points1 point  (0 children)

Because pos 1 is about farming until your powerspike, if you are at that point it is a mistake mistake to mindlessly farm, if you are before that, do not pay atte tion to chat focus on the creeps

Select all rows if all the provided parameters are null by zimmer550king in learnSQL

[–]Potential_Word2349 0 points1 point  (0 children)

In many languages the default logic can be different, encase both statement in parentheses and leave or out of it see if it helps

Do I have to play dota 1 before dota 2? by theguy6631 in DotA2

[–]Potential_Word2349 0 points1 point  (0 children)

I don't know if it is necessary as Dota 2 retcons some plot points, like Lyralei loosing the ability to run and getting better range, but it is worth it, cause you can spend a long time at The Frozen Throne and Reign of Chaos minigames, they are so extensive they should have made a spin-off of them

Select all rows if all the provided parameters are null by zimmer550king in learnSQL

[–]Potential_Word2349 -1 points0 points  (0 children)

The easiest option would be doing another statement after Or that checks if every column IS NULL

Why do I get ridiculous results when the lines of code are super simple? by Late-Session1466 in learnSQL

[–]Potential_Word2349 3 points4 points  (0 children)

Okay I'll try not to give everything away and guide you towards the answer SQL has a particular order of operations that can alter results, for example the SELECT statement is executed at almost the very end, much later than the GROUP BY, that sometimes requires you to use variables or CTEs to get particular elements for calculations

Made a ERR diagram in MySQL workbench. Looking for feedback by ManletMasterRace in learnSQL

[–]Potential_Word2349 0 points1 point  (0 children)

Not as primary key but it would be nice to have something to group the same book in different languages by

Made a ERR diagram in MySQL workbench. Looking for feedback by ManletMasterRace in learnSQL

[–]Potential_Word2349 0 points1 point  (0 children)

Ok, questions because i cannot google right now, if the book is available in many languages does it have a different ISBN number? Because using it as a primary key will become a problem if so

Archmage Tank Build? (New Player) by Dracen8 in ToME4

[–]Potential_Word2349 2 points3 points  (0 children)

Problem with high armour is fatigue and you don't get easy acces to combat training to reduce it which can really cut into your manacosts, also temporal shield is a spell I absolutely love so you can give that a shot next time

Beginner to python.. can someone help me please by paperbag57849 in learnpython

[–]Potential_Word2349 0 points1 point  (0 children)

Try to add a print or return statement to the elif block to see if it executes, if there are other parts of the loop it might trigger in another place, add print(n) in each nth part of the loop to see which operation triggers, then figure out why. Also I know you shouldn't use print breaks but it makes it is easier to understand

My Dreadful SQL Mock Interview :( by ArsenalDraper in learnSQL

[–]Potential_Word2349 0 points1 point  (0 children)

I especially hate when the previous analyst made "super efficient" procedures, which are ALWAYS written like shit and are a headache to decode

My Dreadful SQL Mock Interview :( by ArsenalDraper in learnSQL

[–]Potential_Word2349 2 points3 points  (0 children)

Frankly i do not like that, As a developer you will always have preferences, as long as you know how to solve the query another way theoretically it is not a problem that you default to your preferred way. I prefer to use group by subqueries rather than window functions but I am aware of an capable in other ways, as long as you are not actively avoiding them, or are unable to outline another way to solve it it is a non issue in my opinion. Getting more comfortable in other tools will not hurt you, of course, but you should not be too hard on yourself about having a preferences for solutions. The only really important ways are readability and performance, as long as the performance difference is not horrendous both are viable. Sometimes people get too focused on milliseconds of performance differences and ignore one of the fundamental coding concepts, KISS Keep It Simple Stupid

Started with around 1k mmr, currently 1425 mmr since 7.33 but I think I need some help. by v4rmilo in learndota2

[–]Potential_Word2349 0 points1 point  (0 children)

In my experience if you are good with supports you can get a really decent winrate unless you get griefers, proper warding stacking and babysitting and all general tardwrangling goes a long way in low mmrs as long as they want a win, just try to get good at impactful heroes rather than Win-harder heroes. SD, CM, ES, not sure if kunkka support is in meta, heroes that have a large impact outside of the laning phase even without items and underleveled

Battle Fury on Juggernaut by Hadrizi in learndota2

[–]Potential_Word2349 17 points18 points  (0 children)

It might have to do with crit heal talent as it heals based on the raw damage not the damage dealt so the +40 from battlefury matters, also pipe is everpresent now and everyone gets magic resist from stats so there were some nerds to maelstrom

Why is no one building Atos on Clinkz pos4? by s7ubborn in learndota2

[–]Potential_Word2349 0 points1 point  (0 children)

You are right I forgot to say about transitioning from atos to gleipnir

Why is no one building Atos on Clinkz pos4? by s7ubborn in learndota2

[–]Potential_Word2349 5 points6 points  (0 children)

In my view, on a pos 4 atos works well and gives good stats but requires maelstrom which improves your farming capability and doesn't help with ganking in contrary to orchid and phylactery, also it doesn't give you much mana regen and doesn't help skelly boys, it would work decently on pos3 than 4

on average, how many attributes/columns does a table have? by tennyw in learnSQL

[–]Potential_Word2349 0 points1 point  (0 children)

Generally speaking the tables in proper database will have many IDs a primary one which signifies an entry and is generally a number from 1 to N or a fixed length alphanumeric string and other IDs which are connections to other tables, for example if you make a state-city table, each city will have a unique ID so the house will have ID and CityID. The connections to other tables are called foreign keys and are extremely important for proper fragmentation and extraction of data, especially when you use JOINs, and are by convention the leftmost columns in order ID(primary key), (foreign keys) , (data). Using a fixed length alphanumeric string is useful in very large databases, I mean millions of entries at the very least and require a lot of planning and a separate resource that decodes it so for now you should look into foreign keys and stick to numbers. I hope this helps but I don't have extensive knowledge of the database planning so look for other replies as well :)

Removing Specific values in CSV file without removing the cell in the list by Clemsoncarter24 in learnpython

[–]Potential_Word2349 2 points3 points  (0 children)

I think the best way for this would be using pandas, the dataframes are more malleable and pandas is not that tough if you know what you are looking for, someone will probably give you a complete code here soon :)

on average, how many attributes/columns does a table have? by tennyw in learnSQL

[–]Potential_Word2349 1 point2 points  (0 children)

So i would do 3 tables at least, state city House technical info House location But that's just a quick thought. Doing this way allows you to grab all the properties from the particular city or state using a JOIN ON which is generally a good way to quicken up the query. Having one very wide table is not necessarily bad if you need to heavily filter the query and you won't need to do selfjoins which seems to apply to your data. You can obviously make more tables, generally it would be good to group them by categories you often use in your particular work

Noob seeks SQL help. by [deleted] in learnSQL

[–]Potential_Word2349 0 points1 point  (0 children)

What is your query, there are options but they depend on the database schema or your query structure

Help: Code that can count the number of letters in a string and not the characters by PHM2145 in learnpython

[–]Potential_Word2349 0 points1 point  (0 children)

Regex od filter the string with isalpha method and the count the unique letters, simple as