HN user

hotdamnson

44 karma
Posts0
Comments16
View on HN
No posts found.

I mitigate the imbalance by minimalism.

For example I spend only about 20% of what I make (after taxes). It's not that difficult for IT guys and remote world we live in right now.

It's worth noting that the actual Saudis make up only 62% of the country population(according to wikipedia). The rest are mostly semi-slaves / slaves from Indian subcontinent / south east Asia. It's not as extreme as cases of Oman or UAE but still noticeable.

Why do these new big thing databases make SQL look like some witchcraft?

Here is some proper SQL query:

SELECT DISTINCT

       r.id,  

       r.owner_id,  

       r.name,  

       COUNT(r.id) OVER (PARTITION BY r.id) AS COUNT  

  FROM repository r  

  JOIN star s ON s.repository_id = r.id  
ORDER BY 4 DESC;

Here in Thailand, there were cases where the shop sent a package containing cash amount paid by the customer because they didn't have the item they sold. This was an attempt to avoid some negative repercussions from the platform they were selling on (Shoppe, Lazada). Totally mental.

This is a very poorly written SQL.. Try some modern syntax: select DISTINCT sale_person_id, sale_person_name, max(no_products_sold) over (partition by sale_person_id) AS max_products_sold, commission_percentage, sales_department from no_products_sold;