#aggregate function

[tpointtechblog]

Mastering Aggregate Functions in SQL: A Comprehensive Guide

Introduction to SQL: In the realm of relational databases, Structured Query Language (SQL) serves as a powerful tool for managing and manipulating data. Among its many capabilities, SQL offers a set of aggregate functions that allow users to perform calculations on groups of rows to derive meaningful insights from large datasets.

Learn how to use SQL aggregate functions like SUM, AVG, COUNT, MIN, and MAX to analyze data efficiently. This comprehensive guide covers syntax, examples, and best practices to help you master SQL queries for data analysis.

[mothcpu]

If you stare directly at reality, you'll end up going blind!

[oreoambitions]

I know that People In General are Not Doing Great bc of a general decline in basic ability to order a cup of coffee, but lately it's gotten worse in ways that would be funny if I weren't concerned about the implications re: the avg person's baseline intelligence. Today's winners were: - attempting to order a large latte by saying "Latte but more?" (that was the entire opening sentence, by the way - no greeting whatsoever) - attempting to order a large latte but could not remember the word "large" and resorted to increasingly frustrated gesturing - could not remember the word "large" and asked for an "extended latte" which turned out to mean large and also extra foam are y'all okay

[sendmyresignation]

every time someone mentions the way music-related algorithms work in the best interests of major labels pushing their artists for their own gain and therefore are often embedded with bias and cut off new avenues of discovery everyone comes out of the woodwork to mention "well, anecdotally to my specific circumstance, I've discovered (5) new artists with sub-one thousand regular listeners completely detached from any information or scene or cohesive idea of taste on my weekly currated playlists so therefore algorithms actually work amazing" like what are you talking about. can we be serious please.

[patrice-bergerons]

Bruins players as Excel functions, sorted by usefulness and exactness of match

(you're not the only one bored at work)

the scream I let out when I saw this ask -- I love you

Bergy: =INDEX(MATCH). The bread and butter of all Excel functions. Beautiful, versatile, and powerful, it does two things at once (indexing and matching) and is there to defend your spreadsheet against all errors

Marchy: To us he is =AGGREGATE() which allows you to do all sorts of summary stats in a dynamic way, i.e., via ignoring any grouped out rows, subtotals, and crucially errors, much like the way we overlook his long history of questionable decisions LMAO. To the rest of the league, I am afraid he is a =VLOOKUP() with exact match set to FALSE, which is to say extremely unpredictable and annoying

Pasta: =XLOOKUP(). He is the super dynamic, powerful, next gen function what can I say?

The goalie tandem: =SUMIFS(). Man, the way they are joined at the hip, they are like two functions merged into one AND they keep the world turning -- where would we be without sumifs after all?

Zee: =LARGE() I could not help myself

This is all I've got for now but everyone is welcome to add more for the rest of the squad and I do take constructive criticism.

[hauntedfalcon]

just a heads up, they've fixed this in the latest version of chatGPT

[datawitzz]

What is the AGGREGATE function in Excel|| 19 functions in a single formula|| How to use the AGGREGATE function in excel

What is the AGGREGATE function in Excel What is the AGGREGATE function in Excel – The AGGREGATE function in excel is a conglomerate of functions. We can use 19 functions from this single function. This is just a “Function of Functions” which incorporates multiple functions. It was introduced in the 2010 version. So if you are using an older version then it would reflect #NAME? errors. The excel…

[thedbahub]

Simplify SQL Queries with the OVER Clause

Introduction Have you ever written a complex SQL query that used window functions like ROW_NUMBER(), RANK(), SUM(), or AVG()? If so, you know how tricky it can be to get the syntax just right. Luckily, SQL Server provides a handy feature called the OVER clause that makes these types of queries much simpler to write and understand. In this article, I’ll explain what the OVER clause does and show…

[fratboycipher]

obligatory welcome guide for redditors

A lot of the guides I've seen don't actually seem to understand how reddit works in comparison to tumblr so

your blog is basically your own small subreddit. some people curate this heavily to fit a theme, like a sub, most people don't

reblogs are culturally equivilant to upvotes but functionally equvilant to crossposting

there is an algorithm. it sucks and nobody uses it. turn it off in settings. everything is generally chronological

likes are functionally equivilant to saving a post

you've probably already seen this but change your icon and put something in your bio or people WILL assume you're a bot. personal info not required

generally, anything you would put as a comment on a thread should go in the tags or the replies of a post. only add comments in reblogs if you want it to become part of the base post

tags are mostly equivilant to flairs, used for organization and commentary

your dashboard is an aggregation of everyone you follow

there is an r/all equivilant(trending page) but it sucks and nobody uses it

our search also sucks. your best bet is using tumblr.com/tagged/[TAG] and not /search

there are no mods

by extension, reporting something doesn't put it in front of the mods, it sends it to staff, who may or may not do anything(usually they don't)

there is no karma, there are no karma limits. anyone can reblog anything, comment/reply to anything, or post in any tag

"reposting"(reblogging) old content doesn't matter. people can and will reblog the same post multiple times, including in a row

CAVEAT. reposting someones art(NOT reblogging, making a new post) is a dick move. i know this is commonplace on fandom subs but its not necessary here. everything you post should be [OC] unless you are reblogging. or posting shitty memes

we have our own sitelore, you'll pick it up

(though im not opposed to bringing some over from reddit)

our app also sucks. we do not have third party apps and any that claim to be are scams. sorry

for desktop, most people use the XKit Rewritten extension for QoL improvements and to revert shitty aesthetic updates, much like old.reddit

we have no idea where the porn rules are at either. add a mature content flag to anything you'd get fired for looking at at work, that's about it

finally, from the bottom of my heart, fuck u/spez

[piece-of-mined]

Exactly. Their autogynephelia fetish only tantalizes them if women are forced to be unwilling voyeurs to it.

Now leftists are going “wHy DoEs EvErYoNe SuDdEnLy HaVe A pRoBlEm WiTh GeNdEr NeUtRaL bAtHrOoMs?”

Bitch you haven’t been asking for gender neutral bathrooms. You’ve been fighting to let boys use girls bathrooms.

We have gender neutral bathrooms. That’s not a problem. Your push to keep gendered bathrooms but let men use women’s restrooms is the problem.

In fact gender neutral bathrooms were offered as a solution and ya’ll fear mongered about them because you didn’t think they were good enough.

Don’t ya’ll dare try to change the narrative. You can pretend all you wanted all along was gender neutral bathrooms and conservatives are against that but we all know it’s not true and we have the receipts.

[amplexadversary]

Had one of those dreams about a video game that I'm a little mad I can't play because the mechanics had this fucked-up element that you don't see a lot (I'd say reminiscent of the Zero Escape series)

Basically you start as this character (A) investigating the disappearance of some local youths in this obvious-to-the-player-but-not-the-character super haunted castle/mansion thing.

And what I mean is, there's no proof of it until you start making progress but this place ticks just about every gothic horror and haunted house box the player could have possibly seen up to and including the (generous supply of) filler text when you investigate something irrelevant.

Then you start meeting people who aren't explicitly ghosts, but you do only see them after the entire environment abruptly and inexplicably shifts which can mean anything from your typical snuffed lights and chill air to everything in your immediate surroundings changes to a sharpened and more dangerous looking form of itself to literally winding up in another area, complete with filler observations and a puzzle to solve before you can get the information you want out of the person(s) who've showed up.

Once you move the plot forward, you blink and find the room you were in back to normal (though every time you have one of these conversations, something in another room changes permanently, so the entire accessible map gradually transforms as you progress). (A) has a journal and inventory to keep track of your progress, and for the sake of quality of life there is a menu that tracks all of the progress flags that you have and haven't triggered (so if the player gets lost, they can open it up and go "oh, I'm stuck because here's this cryptic hint that I haven't found everything in the library yet")

This goes on and you start to get a good grasp on the "rules" of the setting and start finding out what is going on in this place. Eventually (A) decides they have enough evidence to actually convince a colleague of theirs to come to this place, partly because they have a solid partial picture of what is going on but it's clear there's still a lot more work to do and partly because this place is starting to give them the absolute creeps and they'd really like the company. (A) gives their colleague (B) a call and (B) rides over on a motorcycle after getting a brief summary.

The player's perspective shifts to (B), who shows up outside where (A) should be waiting with a more thorough report. (A) is not there. This is not particularly strange to either (B) or the player because (A), being the type to hike off to this super haunted place on their own, has also in their section demonstrated that, like a good video game protagonist, instead of sitting patiently and waiting for something they will leave and do something else (read: this game has several "broken bridge" type gates in A's section.)

So now you're (B) and you need to investigate some rooms and solve some puzzles to catch up with (A). You do this. While (A)'s section of the game wasn't strictly linear (you could do several tasks in whatever order you want but you have to trigger every flag before calling B), (B)'s section isn't. None of the rooms (A) has visited are blocked off, and (B) can just blow off portions of their gameplay because their primary goal is to find (A) and get that summary. (B) even at times encourages this, making comments about how it is foolish to speculate without all of the relevant information, and (A) has that information.

(B) has a slightly different interface when you open your menu to look at your findings than (A) does. While (A) had a journal and as many slots for items as they happened to be carrying at the time, (B) has 13 slots. One for their journal, some with items depending on the progress you've made, and several that are empty.

The sun is shown as being low in the sky when (B) arrives. As you check each room, the ones with windows show a change in angle and gradually darken. When you've checked the last room, it's dark outside. There is nothing preventing you from returning to the puzzles you may have passed and working on them. You have free roam of the building, and your objective remains unchanged. No further guidance from the game. If you go back into the entrance however, there is a change.

(A) is tied to some kind of pillar with a lantern hanging over them. They are sobbing. There is something covering their mouth. (B) rushes over to them and begins to untie them, and as this happens, (B), now panicking, starts to go over the information they have, incomplete as it is. This is presented as a series of 13 questions directed at the player, relating to what happened to (A). Some multiple-choice, and some fill-in-the blank (with items).

The first question is an obvious one; the answer is the option that sounds like (B)'s internal monologue. The rest of the questions range in difficulty. Some can be guessed, others have no obvious answer unless you have the item tied to them. If you get a question wrong, the scene proceeds, but the text from the answer you selected turns red as it is shifted into the narrative text box. After (B) finishes untying (A), and comforts them (it's obvious by now that they're close), the ending to (B)'s section plays, and which one it is out of 20 possibilities is tied to the first question you got wrong.

There are some endings that are downright silly, such as if you get the first question wrong, (B) turns out to have either been possessed by a ghost, or be an imposter that waylaid the real (B) on the way in. Generally, the more sense it makes for the player to have gotten a question wrong, the more in-line the ending is with the genre and plot (ie getting a guessable one wrong gives you an ending where the battery on B's motorcycle dies as they try to leave, and gives no hint, while getting a more obscure one wrong gives an ending where an uncountable amount of frenzied teenagers swarm the castle as A and B try to escape, and the scene shifts to the puzzle you would need to solve to get that question right.)

Question 13 is most likely impossible for a player to get right the first time they try the quiz. If the player hasn't completely filled (B)'s inventory they won't have the item needed to answer "What is in (A)'s pocket?" (B) won't have the item unless they've completed all of their section's puzzles, and chances are, the player has skipped at least one of these puzzles because (B) doesn't have any reason to do them, at least right away, and they also likely stumble upon the lantern scene before getting back around to them.

This is where the "Progress" menu becomes very obviously necessary, because once you're out of the cutscene, you get dumped to that screen, where you can skip back to (B)'s section and start solving those puzzles, or to the start of the quiz and change your answers.

To get the 13th item you need to solve all 11 puzzles. Some of these give you duplicates of information (A) has figured out. Some of these answer questions in their menu description that could have been easily guessed, but also are needed to fill a blank in one of the two questions with several blanks to fill. A couple of these give you information that completely recontextualizes some of (A)'s discoveries (thus making their related questions very hard to guess). Each puzzle you solve changes one thing that the player may or may not notice based on their experience with (A)'s section: chains start appearing on the front entrance, which upon examining them (B) will state that they aren't secured to anything and that the door is still usable.

The 11th puzzle will add a big lock to those chains and bar the door. (B)'s responds to this with distress and the objective changes to "Find a way out of this place." This is when (B) starts seeing weird changes to the environment, and progress lies in the direction where these changes are creepier and more concentrated. Once the player makes it to the basement, either by following these changes or by trial-and-error, (B) suddenly stops being in the basement and has their first encounter with one of the not-explicitly ghosts in their weird ghost environment.

(B) eventually convinces the ghost to actually help them, and the ghost gives them an ornate key and a cryptic hint before dropping them back in the creepy basement. After using the key to open the front door it transforms into the last piece of evidence just before the quiz cutscene starts: the broken-off tip of a knife.

The player now has everything they need to correctly answer all 13 questions and get the true ending. Which, once again, radically changes the context of everything that came before it.

So. Yeah. I'm kind of sad I can't actually play this game. Because it doesn't exist. And the weird blend of tone and mechanics and other elements from things like Zero Escape and Silent Hill and Eternal Darkness and Ace Attorney that I like has me wanting.

[treasure-mimic]

So, let me try and put everything together here, because I really do think it needs to be talked about.

Today, Unity announced that it intends to apply a fee to use its software. Then it got worse.

For those not in the know, Unity is the most popular free to use video game development tool, offering a basic version for individuals who want to learn how to create games or create independently alongside paid versions for corporations or people who want more features. It's decent enough at this job, has issues but for the price point I can't complain, and is the idea entry point into creating in this medium, it's a very important piece of software.

But speaking of tools, the CEO is a massive one. When he was the COO of EA, he advocated for using, what out and out sounds like emotional manipulation to coerce players into microtransactions.

"A consumer gets engaged in a property, they might spend 10, 20, 30, 50 hours on the game and then when they're deep into the game they're well invested in it. We're not gouging, but we're charging and at that point in time the commitment can be pretty high."

He also called game developers who don't discuss monetization early in the planning stages of development, quote, "fucking idiots".

So that sets the stage for what might be one of the most bald-faced greediest moves I've seen from a corporation in a minute. Most at least have the sense of self-preservation to hide it.

A few hours ago, Unity posted this announcement on the official blog.

Effective January 1, 2024, we will introduce a new Unity Runtime Fee that’s based on game installs. We will also add cloud-based asset storage, Unity DevOps tools, and AI at runtime at no extra cost to Unity subscription plans this November. We are introducing a Unity Runtime Fee that is based upon each time a qualifying game is downloaded by an end user. We chose this because each time a game is downloaded, the Unity Runtime is also installed. Also we believe that an initial install-based fee allows creators to keep the ongoing financial gains from player engagement, unlike a revenue share.

Now there are a few red flags to note in this pitch immediately.

Unity is planning on charging a fee on all games which use its engine.

This is a flat fee per number of installs.

They are using an always online runtime function to determine whether a game is downloaded.

There is just so many things wrong with this that it's hard to know where to start, not helped by this FAQ which doubled down on a lot of the major issues people had.

I guess let's start with what people noticed first. Because it's using a system baked into the software itself, Unity would not be differentiating between a "purchase" and a "download". If someone uninstalls and reinstalls a game, that's two downloads. If someone gets a new computer or a new console and downloads a game already purchased from their account, that's two download. If someone pirates the game, the studio will be asked to pay for that download.

Q: How are you going to collect installs? A: We leverage our own proprietary data model. We believe it gives an accurate determination of the number of times the runtime is distributed for a given project. Q: Is software made in unity going to be calling home to unity whenever it's ran, even for enterprice licenses? A: We use a composite model for counting runtime installs that collects data from numerous sources. The Unity Runtime Fee will use data in compliance with GDPR and CCPA. The data being requested is aggregated and is being used for billing purposes. Q: If a user reinstalls/redownloads a game / changes their hardware, will that count as multiple installs? A: Yes. The creator will need to pay for all future installs. The reason is that Unity doesn’t receive end-player information, just aggregate data. Q: What's going to stop us being charged for pirated copies of our games? A: We do already have fraud detection practices in our Ads technology which is solving a similar problem, so we will leverage that know-how as a starting point. We recognize that users will have concerns about this and we will make available a process for them to submit their concerns to our fraud compliance team.

This is potentially related to a new system that will require Unity Personal developers to go online at least once every three days.

Starting in November, Unity Personal users will get a new sign-in and online user experience. Users will need to be signed into the Hub with their Unity ID and connect to the internet to use Unity. If the internet connection is lost, users can continue using Unity for up to 3 days while offline. More details to come, when this change takes effect.

It's unclear whether this requirement will be attached to any and all Unity games, though it would explain how they're theoretically able to track "the number of installs", and why the methodology for tracking these installs is so shit, as we'll discuss later.

Unity claims that it will only leverage this fee to games which surpass a certain threshold of downloads and yearly revenue.

Only games that meet the following thresholds qualify for the Unity Runtime Fee: Unity Personal and Unity Plus: Those that have made $200,000 USD or more in the last 12 months AND have at least 200,000 lifetime game installs. Unity Pro and Unity Enterprise: Those that have made $1,000,000 USD or more in the last 12 months AND have at least 1,000,000 lifetime game installs.

They don't say how they're going to collect information on a game's revenue, likely this is just to say that they're only interested in squeezing larger products (games like Genshin Impact and Honkai: Star Rail, Fate Grand Order, Among Us, and Fall Guys) and not every 2 dollar puzzle platformer that drops on Steam. But also, these larger products have the easiest time porting off of Unity and the most incentives to, meaning realistically those heaviest impacted are going to be the ones who just barely meet this threshold, most of them indie developers.

Aggro Crab Games, one of the first to properly break this story, points out that systems like the Xbox Game Pass, which is already pretty predatory towards smaller developers, will quickly inflate their "lifetime game installs" meaning even skimming the threshold of that 200k revenue, will be asked to pay a fee per install, not a percentage on said revenue.

[IMAGE DESCRIPTION: Hey Gamers!

Today, Unity (the engine we use to make our games) announced that they'll soon be taking a fee from developers for every copy of the game installed over a certain threshold - regardless of how that copy was obtained.

Guess who has a somewhat highly anticipated game coming to Xbox Game Pass in 2024? That's right, it's us and a lot of other developers.

That means Another Crab's Treasure will be free to install for the 25 million Game Pass subscribers. If a fraction of those users download our game, Unity could take a fee that puts an enormous dent in our income and threatens the sustainability of our business.

And that's before we even think about sales on other platforms, or pirated installs of our game, or even multiple installs by the same user!!!

This decision puts us and countless other studios in a position where we might not be able to justify using Unity for our future titles. If these changes aren't rolled back, we'll be heavily considering abandoning our wealth of Unity expertise we've accumulated over the years and starting from scratch in a new engine. Which is really something we'd rather not do.

On behalf of the dev community, we're calling on Unity to reverse the latest in a string of shortsighted decisions that seem to prioritize shareholders over their product's actual users.

I fucking hate it here.

-Aggro Crab - END DESCRIPTION]

That fee, by the way, is a flat fee. Not a percentage, not a royalty. This means that any games made in Unity expecting any kind of success are heavily incentivized to cost as much as possible.

[IMAGE DESCRIPTION: A table listing the various fees by number of Installs over the Install Threshold vs. version of Unity used, ranging from $0.01 to $0.20 per install. END DESCRIPTION]

Basic elementary school math tells us that if a game comes out for $1.99, they will be paying, at maximum, 10% of their revenue to Unity, whereas jacking the price up to $59.99 lowers that percentage to something closer to 0.3%. Obviously any company, especially any company in financial desperation, which a sudden anchor on all your revenue is going to create, is going to choose the latter.

Furthermore, and following the trend of "fuck anyone who doesn't ask for money", Unity helpfully defines what an install is on their main site.

While I'm looking at this page as it exists now, it currently says

The installation and initialization of a game or app on an end user’s device as well as distribution via streaming is considered an “install.” Games or apps with substantially similar content may be counted as one project, with installs then aggregated to calculate the Unity Runtime Fee.

However, I saw a screenshot saying something different, and utilizing the Wayback Machine we can see that this phrasing was changed at some point in the few hours since this announcement went up. Instead, it reads:

The installation and initialization of a game or app on an end user’s device as well as distribution via streaming or web browser is considered an “install.” Games or apps with substantially similar content may be counted as one project, with installs then aggregated to calculate the Unity Runtime Fee.

Screenshot for posterity:

That would mean web browser games made in Unity would count towards this install threshold. You could legitimately drive the count up simply by continuously refreshing the page. The FAQ, again, doubles down.

Q: Does this affect WebGL and streamed games? A: Games on all platforms are eligible for the fee but will only incur costs if both the install and revenue thresholds are crossed. Installs - which involves initialization of the runtime on a client device - are counted on all platforms the same way (WebGL and streaming included).

And, what I personally consider to be the most suspect claim in this entire debacle, they claim that "lifetime installs" includes installs prior to this change going into effect.

Will this fee apply to games using Unity Runtime that are already on the market on January 1, 2024? Yes, the fee applies to eligible games currently in market that continue to distribute the runtime. We look at a game's lifetime installs to determine eligibility for the runtime fee. Then we bill the runtime fee based on all new installs that occur after January 1, 2024.

Again, again, doubled down in the FAQ.

Q: Are these fees going to apply to games which have been out for years already? If you met the threshold 2 years ago, you'll start owing for any installs monthly from January, no? (in theory). It says they'll use previous installs to determine threshold eligibility & then you'll start owing them for the new ones. A: Yes, assuming the game is eligible and distributing the Unity Runtime then runtime fees will apply. We look at a game's lifetime installs to determine eligibility for the runtime fee. Then we bill the runtime fee based on all new installs that occur after January 1, 2024.

That would involve billing companies for using their software before telling them of the existence of a bill. Holding their actions to a contract that they performed before the contract existed!

Okay. I think that's everything. So far.

There is one thing that I want to mention before ending this post, unfortunately it's a little conspiratorial, but it's so hard to believe that anyone genuinely thought this was a good idea that it's stuck in my brain as a significant possibility.

A few days ago it was reported that Unity's CEO sold 2,000 shares of his own company.

On September 6, 2023, John Riccitiello, President and CEO of Unity Software Inc (NYSE:U), sold 2,000 shares of the company. This move is part of a larger trend for the insider, who over the past year has sold a total of 50,610 shares and purchased none.

I would not be surprised if this decision gets reversed tomorrow, that it was literally only made for the CEO to short his own goddamn company, because I would sooner believe that this whole thing is some idiotic attempt at committing fraud than a real monetization strategy, even knowing how unfathomably greedy these people can be.

So, with all that said, what do we do now?

Well, in all likelihood you won't need to do anything. As I said, some of the biggest names in the industry would be directly affected by this change, and you can bet your bottom dollar that they're not just going to take it lying down. After all, the only way to stop a greedy CEO is with a greedier CEO, right?

(I fucking hate it here.)

And that's not mentioning the indie devs who are already talking about abandoning the engine.

[Links display tweets from the lead developer of Among Us saying it'd be less costly to hire people to move the game off of Unity and Cult of the Lamb's official twitter saying the game won't be available after January 1st in response to the news.]

That being said, I'm still shaken by all this. The fact that Unity is openly willing to go back and punish its developers for ever having used the engine in the past makes me question my relationship to it.

The news has given rise to the visibility of free, open source alternative Godot, which, if you're interested, is likely a better option than Unity at this point. Mostly, though, I just hope we can get out of this whole, fucking, environment where creatives are treated as an endless mill of free profits that's going to be continuously ratcheted up and up to drive unsustainable infinite corporate growth that our entire economy is based on for some fuckin reason.

Anyways, that's that, I find having these big posts that break everything down to be helpful.

[vipintiwarionline]

Aggregate Functions in SQL

https://vipintiwarionline.blogspot.com/2023/04/aggregate-function-in-sql.html

[drdemonprince]

what do you think is the answer to dealing with the stereotypical “roommate won’t do dishes bc of trauma/sensory issues”? like sure that’s possible it’s difficult & people should be aware of their needs, but when it begins affecting other people, i feel like someone has to consider other solutions—i.e. using paper plates instead of ones they have to wash. it’s also complicated when racial & gender dynamics come in to play. and then when i think on myself as an autistic white trans guy how can i both recognize where i need support but balance it with not recreating bad dynamics? I’m just not sure how we have these conversations while still validating folks experiences & dismissing their problems. we all deserve help but we also can so easily overly rely on others & burn them out especially if we have privilege over them. disability, especially invisible disabilities often become a shield for white folks & men it feels like to get away with shitty behaviors

I honestly think that a big problem people encounter in navigating such issues is that they make what is ultimately going to have to be a personal negotiation of limits and needs into something that is far more symbolic and abstract. it's almost impossible not to, if you care about social justice issues, and I think there are good intentions when people try to be mindful of how race and gender alongside interplay with this stuff, but in practice a lot of times people use their political ideals as a reason to argue against their own feelings or to not be honest about their feelings. people feel like they don't have the right to say that they cannot do something or need support, or that they're pissed off, in an individual level relationship, because they are treating both themselves and their roommate or partner as a symbol of an entire group. I think a person has to be able to tell their roommate when they are being an asshole. I think a person should just be straight up if doing the dishes is something that's not generally going to happen for them -- in unmasking autism I profile Reese Piper, an autistic sex worker who just straight up tells her prospective roommates that doing the dishes is not something she can do, so then they know what they are getting into and can work around it. honest conversations about what a person is and is not capable of and what they need really can vanquish a lot of so-called weaponized incompetence and other domestic issues long before they occur. but all parties involved have to be operating based on good faith. unfortunately not everyone is, sometimes people use their identities or their roommates guilt around structural oppression in order to pressure them to do things that they cannot do, and conversely it is very common for a white or TME roommate to weaponize anti blackness or transmisogyny against a roommate who speaks up about any inequity and portray them as the aggressive one. but I think before somebody gets way way too much in their own head about how a particular conflict looks or what structural issues might be relevant in the aggregate, they really have to start from a baseline level of self-acceptance and the ability to articulate both which household tasks are hard or impossible for them, and when they are fucking cheesed at their roommate for not doing what seems like their fair share. if you feel like you can't name those things, you're never going to actually have a respectful functioning relationship.

[fairygodsystem]

Do you have any system names for just the grouping that aren't system or collective?

We are really wanting a one worded collective name

♡ Alternatives to "system" or "collective" Master-list ♡

Association　　Assembly　　Aggregation　　Assemblage　　Assortment　　Array　　Alliance

Band　　Body　　Batch　　Battery　　Bunch　　Bundle　　Battalion　　Bracket　　Brigade

Class　　Club　　Chain　　Circle　　Crew　　Collection　　Cluster　　Clutch　　Clique　　Clump　　Clot　　Combine　　Conglomerate　　Congregation　　Crew　　Crowd　　Company　　Collaborative　　Communal　　Cooperative　　Common　　Corporation　　Compilation　　Collation　　Caboodle　　Convocation　　Cumulation　　Constellation　　Clan　　Consort　　Crop　　Coalition　　Classification　　Conspiracy　　Cabal　　Coven　　Corps

Division

Establishment　　Enterprise

Faction　　Function　　Formation　　Foundation　　Fellows　　Fellowship　　Family　　Force

Group　　Gathering　　Grade　　Gaggle　　Grouping　　Gild　　Guild　　Genus　　Generation

Herd　　Horde　　Hoard　　Heap　　Huddle　　Hodgepodge

Institute　　Institution

Lot　　League　　Legion　　Layout　　Lads

Mass　　Medley　　Mess　　Miscellany　　Mobilization　　Muster　　Mess　　Melt　　Mutual　　Mob

Number　　Network

Operation　　Outfit　　Order

Platoon　　Party　　Parcel　　Posse　　Phalanx　　Pack　　Personnel　　Pile

Round　　Ring

School　　Squad　　Squadron　　Set　　Species　　Syndicate　　Staff　　Stack　　Stock　　Suite

Team　　Troop　　Trust

Union

Variety