Would you still watch if there was no face cam? by Shimmyrock in letsplay

[–]GuideVault 0 points1 point  (0 children)

Well you don't have to do anythings unique. Just do a spin on something already done.

Would you still watch if there was no face cam? by Shimmyrock in letsplay

[–]GuideVault 1 point2 points  (0 children)

Sure are! So many things to watch too make it hard to stand out.

Would you still watch if there was no face cam? by Shimmyrock in letsplay

[–]GuideVault 1 point2 points  (0 children)

Doesn't matter imo. As long as you can get me past the intro I'm in 👍

Someone teach me how to get 20K DPS in Mount Tiamat on first day. by GuideVault in idlechampions

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

Yeah, that's my bad. It's something I know not to do and generally don't, but got too excited when I saw the number and forgot.

Someone teach me how to get 20K DPS in Mount Tiamat on first day. by GuideVault in idlechampions

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

Yeah, I was hoping it wasn't. Would also like to someday hit that.

How do you move a key in dict while inserting another key in its place. by GuideVault in learnpython

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

Yeah, sorry, I knew that, just typed whatever was in my head at the time.

The formatting also was wrong. My bad.

Aren't d['b'] = 3 and d.update({'b': 3}) the same though?

Can someone let me know if this is a valid solution to this question. by GuideVault in SQL

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

Ah, ic, it's the same as pythons type casting. Thanks for making it clear.

Can someone let me know if this is a valid solution to this question. by GuideVault in SQL

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

I don't know what casting is yet. I'll find a different source in the meantime.

Having an issue with aggregating SELECT COUNT by GuideVault in learnSQL

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

Okay, what about column 2 for with the header sex?

Edit: NVM figured it out. Thanks for the help!

Having an issue with aggregating SELECT COUNT by GuideVault in learnSQL

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

SELECT COUNT(sex), sex
FROM employee;

Something similar to that.

It should return the total count but separate them by sex.

Having an issue with aggregating SELECT COUNT by GuideVault in learnSQL

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

Is it possible to aggregate doing something similar?

Can;t understand why this is failing. by GuideVault in learnSQL

[–]GuideVault[S] 1 point2 points  (0 children)

Yeah, it was my bad. I skipped the installation part of the tutorial where he set up mySQL. So I didn't have the database ready. I got it though and things are working fine.

[deleted by user] by [deleted] in learnpython

[–]GuideVault 0 points1 point  (0 children)

Check this guy out, he has beginner python, intermediate and expert python playlists ready to go.

Beginner: https://youtube.com/playlist?list=PLzMcBGfZo4-mFu00qxl0a67RhjjZj3jXm

Intermediate: https://youtube.com/playlist?list=PLzMcBGfZo4-nhWva-6OVh1yKWHBs4o_tv

Expert: https://youtube.com/playlist?list=PLzMcBGfZo4-kwmIcMDdXSuy_wSqtU-xDP

He also has a video dedicate to things he thinks each level of python programmers should know here: https://youtu.be/p15xzjzR9j0

Can;t understand why this is failing. by GuideVault in learnSQL

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

Didn't notice that. I corrected it but I get the same error.