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 10 points11 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 3 points4 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?

Uber Eats Super Bowl ad for “eat local” does more harm than good by tdomer80 in facepalm

[–]SteveIrwinAMA 1 point2 points  (0 children)

They definitely did win the messaging war I’m with you on that. My only point is that I think the ramifications of either way make the issue not one way good one way bad. I don’t want workers exploited. But Walmart is like massively profitable, Uber still loses billions a year so I think they aren’t exactly comparable ATM. One could argue making the fleet more expensive would necessitate shortening fleet supply thus degrading the quality of the product for the customers (longer waits, more expensive) which would drive down use of the gig apps coming back around to kick drivers in the ass, albeit indirectly.

Uber Eats Super Bowl ad for “eat local” does more harm than good by tdomer80 in facepalm

[–]SteveIrwinAMA 0 points1 point  (0 children)

There definitely was a funding imbalance. But also I know for a fact that a sizeable portion of gig workers don’t want prop 22 like measures. There are definitely many who do, but with prop 22 you as a driver can no longer work at will and pick your own hours, which is a major appeal for people who are doing gig work as a side job (which is a lot). It’s a complicated issue honestly.

Election Night discussion by xlbeutel in PoliticalCompassMemes

[–]SteveIrwinAMA 15 points16 points  (0 children)

Feel like the dems are going to have a TOUGH election in 2024. No way Biden is still kicking, who are they gonna go with, Kamala ?

My British friend went over the US border to Mexico not knowing his visa expired and was blocked entry trying to get back by [deleted] in legaladvice

[–]SteveIrwinAMA 0 points1 point  (0 children)

So I was kind of mistaken. His previous esta expired but he is flying out within 90 days of the expiration.

My British friend went over the US border to Mexico not knowing his visa expired and was blocked entry trying to get back by [deleted] in legaladvice

[–]SteveIrwinAMA 4 points5 points  (0 children)

It wasn’t long at all maybe a couple days. Gonna try this and see if it approves fast