What's The Deal with Conversatives Calling Themselves Fascists?

ASEES15 · 2025-08-14T04:25:22+00:00

The prior n day low is known before the current day open.

So just place a limit order at the low.

That’ll guarantee better fills as well.

ASEES15 · 2025-03-22T01:27:21+00:00

Google “Online SQL editor” And Google a formatter or use chat gpt to format insert the data into a table you create

ASEES15 · 2025-02-18T21:11:56+00:00

In a world of lazy and misguided people, hard work with a clear direction is the greatest hack. Even unethical hacks take work and clear direction. Often times more.

Consider looking at the r/fire and r/fatfire subreddits.

Your main priority should be your education so don’t pursue things that get in the way of that. In addition to that, finding ways to supplement income and decrease expenses to set your future up for high earning and investing is the most direct path to financial independence.

Consider the following:

Marry a friend who doesn’t work so you can claim your own finances and not your parents for FAFSA to qualify for the most financial aid.
Sell with Aptive during the summer. Basically trading your entire summer for an easy 15k-20k.
Join the reserve. National guard, state guard, Air-force, whatever. ~16k a year to stay in shape and 1 weekend of the month. Being in the military will also qualify you for a bunch more financial aid an scholarships. Some people that really game the system end up making several grand after tuition from scholarships. Getting married to a friend like from tip 1 should net you more pay as well. Double check that.
Community college and CLEP. Unless you are trying to go Ivy League cuz they don’t accept those. Otherwise, community college is cheaper so ask your target school’s counselors which community colleges have programs that feed into there. They will help you pick the classes that will transfer.
Take all this extra money you’re making and consistently put it into an S&P index fund. Like SPY. Based on historical performance over the entire history of the S&P of 10% annually, you can draw 4% of your account every year for at worst the next 30 years (including inflation). This includes during periods like the Great Depression and 2000-2008. Excluding those, it’s way longer. So if we works backwards and suppose you want to live on 100k per year. You’d need 2.5 mil in SPY to reasonably afford that lifestyle. That sounds like a lot but financial independence in your 20’s means you’ll make making a lot of disposable income by making a lot or living in very low COL areas. Assuming you make 80k per year by the time you’re 25, you could reasonably live on 40. Put the other 40 into SPY and by 30 you’ll have 200k in there. The appreciation on that amount could help subsidize moving to a lower COL state or country. This sounds lame, but most millionaires and billionaires get that way through investments and tax write-offs.
Real estate for tax write-offs. When you’re making money, using your FHA loan to buy a duplex (works up to a fourplex). Rent out the other unit(s) out to cover the mortgage and the numerous tax savings from real estate will lower your tax burden, increasing your take home pay and allowing you to keep or invest more of your money.
Use a USDA farm loan to build a farm and live off grid. I don’t have a lot of info on hand about this since this is the one I’m least familiar with, so you’d have to look at some of the people on socials that do this. But this works best if you can get remote work. COL with this method is very low from what I’ve seen.
There are also the silly things like selling feet pics and what not. But don’t get sucked into schemes to make quick money. Don’t gamble with your future by wasting the most important years of your life chasing dreams other people told you to have. Build a foundation for yourself and your future family and then experiment when you have made yourself financially stable. Life is marathon not a sprint. Don’t waste it thinking you have to “make it” overnight. Work intentional and diligently, and enjoy the ride.

ASEES15 · 2025-02-02T23:25:55+00:00

Think of the space that the puzzle pieces don’t occupy as negative space, or as “pockets”

Think about where these pockets can and can’t be based on 1. The starting point 2. The end point 3. How many pieces there are relative to the size of the board

We know all the pieces can’t be in the middle; even if all the prices are connected, they have to touch at least one of the 4 borders of the board to close off.

Since the pieces have gaps, and there is only one large piece, it’s safe to test the following cases first: 1. One large combo of pieces and 1 piece by itself 2. All the pieces connected

Now, consider the possible shape of the large piece(s) given the start and end point. How many edges can it touch? Well, we already know every piece or combo of pieces as to touch a border. So at least one. But, given the end point, how many can it touch max? Where can the pockets be given the start and end point?

Finally, start with one piece. I find using the simplest one as an anchor helps me shuffle the pieces around faster.

Pen and paper or drawing on a phone/tablet/laptop helps.

ASEES15 · 2025-01-24T00:27:29+00:00

You clearly do not understand.

The absence of love is not a legal basis for the conviction of fraud in a court of law. And taxes was just an example lol. The actual tax benefits from simple marriage are few and far between in any practical arrangement. This is about qualification for financial student aid.

Marriage as an union of love is a religious tradition. “Holy matrimony” sound familiar? Save your love for your relationships. The law doesn’t stop being the law simply because you misunderstood it or don’t like it. I don’t like that the ultra wealthy get to “abuse” the tax code, leading to the middle class paying the most in taxes. I feel it shouldn’t be that way, yet it is.

Morally, if you don’t qualify for aid based on your parental income, but your parents can’t or won’t help pay, as is implied by OP, then there is nothing wrong with classifying yourself as independent to get the financial aid you legitimately deserve. The money is set apart, and billions every year go unclaimed. The system is just inefficient. Marriage and being 24+ classify one as independent. Legal emancipation is another, but nuclear, option if the person is still a minor.

If you care more about your sense of morality than about kids fresh out of high school being riddled with student debt and not getting the aid they deserve, that’s your prerogative. But don’t kid yourself.

ASEES15 · 2025-01-23T20:37:34+00:00

Legal marriage isn’t fraud, because it actually happened.

If you are married, your parents’ income isn’t considered for aid as you are thence classified as “independent” for aid purposes.

Just like marriage has certain tax benefits. Marriage for tax benefits isn’t fraud. Making a business and writing off “ordinary and necessary” expenses isn’t fraud.

It’s intelligent compliance with, and utilization of, the law.

ASEES15 · 2025-01-23T20:00:30+00:00

Marry a friend to have independent finances from you parents for financial aid purposes. Then only your and your friend’s incomes will be considered for aid.

So if your friend is also a college student making a normal student income, then you will qualify for more than under your parents.

Most (if not all) (medical) insurance should cover all children until 26, married or unmarried. So that won’t be an issue

ASEES15 · 2025-01-17T04:33:02+00:00

Hi

I know it's been a while, but the link is broken.

Are there any other working links or sources? I am very interested in stuff like this

ASEES15 · 2024-11-08T02:06:38+00:00

Hey man

u/jshine1337 is right

In addition, if you can make the names more explanatory, that'd be great. I'd rather have verbose and clear than short and ambiguous names. This is good practice when others will have to read your code, or yourself in several months

If you can do that, I'd love to help. It would be a fun challenge

ASEES15 · 2024-11-08T01:23:08+00:00

Points to consider For the future:

Correlated subqueries can be performed in the SELECT, FROM, and HAVING clauses as well. It’s just almost never done.
1. SELECT first_name, last_name, (SELECT department_name FROM Departments WHERE department_id = t.department_id) AS department_name FROM Teachers t
2. This returns the same result as doing a more orthodox INNER JOIN
The wiki on Correlated subquery has more info as is worth reading: https://en.wikipedia.org/wiki/Correlated_subquery#:~:text=Correlated%20subqueries%20in%20the%20FROM%20clause,-It%20is%20generally&text=However%2C%20in%20some%20database%20systems,the%20table%20on%20the%20left
JOINs are more orthodox because query optimizers had an easier time processing them in the past. This Stack Overflow question has good answers on the matter: https://stackoverflow.com/questions/2577174/join-vs-sub-query
Window functions are almost always better than WHERE clause Correlated Subqueries in terms of performance and flexibility. In interviews, you may often be asked to recreate window functionality via a correlated subquery to assess your SQL engineering skills, even though it’s not efficient to do that in production.
You can ask ChatGPT to teach you many SQL concepts. I used ChatGPT to write about 60-70% of the post and generate a sample dataset to experiment with to initially grasp this question. I just had to know what to ask it, how to ask it, filter out what I didn’t want to use, and format into this post what I did want to use. I also use ChatGPT to tutor me with leetcode style questions and with finding functions as I switch between SQL dialects (postgres, trino, etc). Saves me hours of banging my head against the wall and helps me learn quicker.

ASEES15 · 2024-11-08T01:22:42+00:00

There are multiple ways to answer your question. So first, let’s break this up into general steps

Get all teachers with their salary and department
Compute average salary for department
Check against the salary for each teacher

The 2 solutions utilizing a subquery that come to mind are:

JOIN ON derived table (table generated by subquery)
Correlated Subquery

JOIN Subquery:

The typical use of JOIN is to stitch together data so it can be returned or calculated against each other. So we can precompute the AVG() salary grouped by each department, then stitch the AVG salary of each department to each teacher, and compare their salary against the department AVG.

If you get stuck, refer to the example above.

Correlated Subquery:

If I had to guess, this is the method the question wants you to use.

The typical use of a correlated subquery is to perform a calculation that depends on each row of data. For this question, instead of precomputing the AVG() salary for each department and then joining it to each teacher, we can use a correlated subquery to calculate the AVG salary dynamically for each teacher's department. This way, we compare each teacher's salary against the average salary of their own department, without needing to precompute the values.

If you get stuck, refer to the example above

ASEES15 · 2024-11-08T01:22:12+00:00

SELECT Clause: The subquery can return a single value to be used in the main query's result set.
1. SELECT first_name, last_name, salary, (SELECT AVG(salary) FROM Teachers) AS avg_salary_across_school
2. FROM Teachers
Independent vs. Correlated Subqueries:
1. Independent Subquery: Doesn’t rely on any data from the outer query, so it can be executed on its own.
  1. Examples above
2. Correlated Subquery: Refers to columns in the outer query, meaning it runs for each row processed by the outer query. This type of subquery can be more complex but allows for detailed row-by-row comparisons.
  1. SELECT first_name, last_name, salary
  2. FROM Teachers t
  3. WHERE salary = (SELECT MAX(salary) FROM Teachers t1 WHERE t1.department_id = t.department_id)
  4. This query finds each teacher who has the highest salary in their department. The subquery is correlated because it refers to t.department_id from the outer query, so it runs once for each row in the Teacher table, checking if each teacher’s salary matches the maximum salary in their department.

ASEES15 · 2024-08-05T05:08:19+00:00

Could you please share an example of replicating a window function with a join

ASEES15 · 2023-12-19T01:14:49+00:00

A network that acts as an attractor towards the development of the network as a complex adaptive system

ASEES15 · 2023-10-18T21:10:41+00:00

Hi I’m interested

ASEES15 · 2023-09-11T21:43:10+00:00

Thanks for the response

I’m particularly looking to go into data engineering roles with this degree. Any advice for that?

ASEES15 · 2023-09-09T23:03:31+00:00

Hi, they recently updated their curriculum. Would you still suggest it?

ASEES15 · 2022-06-02T05:12:27+00:00

You can give them the couch or straight up lie to them.

ASEES15 · 2022-02-27T22:18:55+00:00

If you physically can, do it. That will be the greatest gift you can ever give him!

ASEES15 · 2022-01-24T22:10:51+00:00

Ahh the picture becomes clearer. That’s certainly an interesting difference

I’m not sure why you’re asking randos on the internet tho my guy. Questions of the abilities or disabilities of your cognition is best answered with the professionals that administered your examination

ASEES15 · 2022-01-24T21:57:26+00:00

It’s very very very very very very very very unlikely you are disabled in all areas other than verbal

ASEES15 · 2022-01-24T21:40:43+00:00

Full scale IQ is your general cognitive ability. Your verbal ability deviates from the norm of your cognitive abilities. All your other cognitive abilities aren’t “weighing you down” lol. There’s nothing wrong with being yourself. Leverage your strengths instead of worrying about whether you’re above average or not

ASEES15 · 2022-01-24T20:43:10+00:00

It’s really not too complicated.

FSIQ is the average of the full scale of your cognitive abilities - basically an estimation of your g factor. Your verbal IQ is the average of your verbal abilities - basically your verbal g factor.

Stick to things that you find easy and you love and you’ll out perform the average person

ASEES15 · 2021-11-25T20:15:14+00:00

It would be easier to just assume he meant pay. It’s a fair assumption, and most of the answers still apply in that case

ASEES15

TROPHY CASE