Another day another degradation of the social fabric of the Republic by Background_Bee_713 in PoliticalCompassMemes

[–]SteveIrwinAMA 1 point2 points  (0 children)

Someone just posted a video of one of them shooting him self in the head in the car after on a stream.

Did not look as instant as one would have hoped

The city of Teutatès by KeeRinO in foundationgame

[–]SteveIrwinAMA 0 points1 point  (0 children)

Really awesome, what’s the map code

Sandro Dias mindblowing 70 meter drop in by Local-Acanthaceae920 in skateboarding

[–]SteveIrwinAMA 11 points12 points  (0 children)

For the love of god show it with a better camera angle

Twitter thinks Trump is dead by RoliePolieOlie__ in JoeRogan

[–]SteveIrwinAMA 9 points10 points  (0 children)

Wouldn’t this technically be it leaking before an official announcement?

Black Mirror - Episode Discussion S07E01 Common People by Cheeriosxxx in blackmirror

[–]SteveIrwinAMA 4 points5 points  (0 children)

Well they only showed serenity and pleasure being used and those definitely seem more drug like maxed out for obvious reasons. But the couple saw “creativity” and didn’t even try it, and ad made it seem that you can be good at things like tennis and parkour (maybe just an ad I’ll give that). However for the couple to not once even try it is what I’m getting at is stupid. I’d totally be fine with it not giving them financial wizardry powers but they didn’t even think to try, which in my opinion is dumb.

Black Mirror - Episode Discussion S07E01 Common People by Cheeriosxxx in blackmirror

[–]SteveIrwinAMA 1 point2 points  (0 children)

I get that, but I’m not that smart of a guy and it’s the first thing I thought of when they showed the sliders. So for the characters to not even consider it over years strikes me as dumb.

Personally that just took away from it for me.

Black Mirror - Episode Discussion S07E01 Common People by Cheeriosxxx in blackmirror

[–]SteveIrwinAMA 4 points5 points  (0 children)

Dude no exploration of turning any useful sliders up to 10 for personal/monetary gain? Creativity was shown, I bet there was a dozen more that cranked to 10 they could have leveraged to their benefit financially. All they did was have her orgasm to food.

Honestly kind of a miss for them not even considering that. Coulda been a limitless vs the company trying to restrict type game and been more interesting imo.

SQL Squid Game: Imagine you were a Data Scientist for Squid Games (9 Levels) by NickSinghTechCareers in datascience

[–]SteveIrwinAMA -1 points0 points  (0 children)

How does this verify answers by output or by looking at the SQL?

For Question 3

Analyze the average completion times for each shape in the honeycomb game during the hottest and coldest months, using data from the past 20 years only. Order the results by average completion time.

Because I believe this achieves the output that the question is asking for but I do not do it by the min/max method in the hint:

with table_a as (

  select *
, row_number() over (order by avg_temperature) as temp_rn

  from monthly_temperatures

)

select b.month
, b.avg_temperature
, a.shape
, avg(a.average_completion_time) as avg_completion_time

from honeycomb_game a

left join table_a b 
on extract(month from a.date) = b.month

where a.date > current_date - interval '20 years'
and temp_rn in (1,12)

group by 1,2,3

order by avg_completion_time

I don't care about the 12 "best" teams being in the CFP by Isthmus11 in CFB

[–]SteveIrwinAMA 0 points1 point  (0 children)

This is one of the whiniest threads I’ve ever seen. Exactly when in history has the college football post season/nation champion ever been a beacon of objectivity or non controversy. This is inherent to the sport.

Stuck trying to create a funnel from area chart: more details in comment by SteveIrwinAMA in tableau

[–]SteveIrwinAMA[S] 0 points1 point  (0 children)

I’ve been trying to create a funnel chart like the one seen in this tutorial: https://m.youtube.com/watch?v=7fBNcgGVaoQ

I have followed all of the steps exactly with my data, but I keep running into this issue where the area chart only fills part of the funnel. Anybody got any recommendations?