

I had a fun one this week! I needed to make an SQL query that would aggregate rows by invoice and date, but only aggregate 5 then overflow to a new row. I also needed to access the individual row data because the invoice items weren’t summed, they were displayed on separate columns!
I ask my senior if there’s an easy way to do this, he comes back with “chatgpt says you can assign row numbers then get individual row data with % row number”
I go to Gemini and ask “how to aggregate rows by 5 and get individual row data out?” It says “you can’t” (since when has Ai’s been able to say you can’t do X) So I ask it about the modulo operator and it gives me an example that doesn’t really work. After screwing around for a while I give up and decide I’ll just run this query 3 times. 1 for rows 1-5 then for 6-10 and one more for 11-15 that’s so many rows surely no one will break this.
I wouldn’t say it’s a flop but it is kinda light on content. I finished they game on week 1 played a bit more on week 2 where nothing changed I then uninstalled it. I’m back right now because they’ve released new content though.
Most games do have huge concurrent player falloffs pretty quickly helldivers 2 currently has a 24hr peak of 63k and I wouldn’t call it a flop. Path of Exile 2 currently has a 24hr peak of 17k players, I wouldnt call it a flop. Somehow Dragon age veilguard was at the top of the steam charts in week 1 and we all know it was a flop. I’m not sure steam charts are a particularly useful metric. Fromsoft seems very happy with the amount of players in NightReign and that’s probably the most useful metric we have.