HAVING Filters After GROUP BY?!
HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!
#sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

#Mastodon #stats: I am curious how Mastodon evolves WRT user count etc. There seems to be no complete registry of servers. The aggregators often do not work properly.
Here is one which seems to work:
https://the-federation.info/
The issue: Very few nodes.
Add your node:
`https://the-federation.info/register/<yournode.tld>`
#statistics #socialmedia #socialnetworks #users #usercount #fediverse #aggregation #count #monthlyactiveusers
Ich hatte neulich erst einen Beitrag zur objektorientierten Programmieung in Java geschrieben und mรถchte ergรคnzend dazu heute รผber Assoziationen sprechen. Denn auch diese sind ein wichtiger Teil wenn uns um Verbindungen, bzw. Beziehungen zwischen Klassen geht.
https://magicmarcy.de/assoziationen-in-java-entschuldigung-kennen-wir-uns
#Assoziationen #einfach #bidirektional #Aggregation #Komposition #hat-eine #besteht-aus #one-to-one #one-to-many #eins-zu-eins #eins-zu-viele

Ich hatte neulich erst einen Beitrag zur objektorientierten Programmieung in Java geschrieben und mรถchte ergรคnzend dazu heute รผber Assoziationen sprechen. Denn auch diese sind ein wichtiger Teil wenn uns um Verbindungen, bzw. Beziehungen zwischen Klassen geht.
What Makes an Antibody Hard to Manufacture? Data-Driven Insights
The Features That Matter After training the developability model on 100+ therapeutic antibodies, I looked at the feature importance rankings. The model had learned to weight certain properties more heavily than others when making predictions. Some of these were obvious. Some were surprising. All of them tell us something about what actually makes antibodies difficult to manufacture. The single most predictive feature was aggregation propensity in the complementarity-determining regions [โฆ]https://kemal.yaylali.uk/what-makes-an-antibody-hard-to-manufacture-data-driven-insights/
Conditional Aggregation with CASE?!
CASE inside SUM creates conditional aggregation! You can sum only certain rows based on conditions. This conditional math will transform your data!
#sql #sqltricks #case #sum #conditionalaggregation #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

GROUPING SETS / ROLLUP / CUBE?!
ROLLUP creates MULTIPLE grouping levels! It generates subtotals and grand totals automatically. This one query returns MANY result sets!
#sql #sqltricks #rollup #cube #groupingsets #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql
