1
joeblow2020 1 point ago +1 / -0

Not sure if this link will work right if you are using a phone, but I would recommend going through the "Learn the Basics" on this website, because it lets you actually run the code right on the webpage and see the results, without having to download or install anything.

https://www.learnsqlonline.org/

A few things that are frequently used and might come up that aren't under "The Basics":

  • Under "Joining Tables", go a little farther and get a handle on: [LEFT, RIGHT, INNER, OUTER ] JOIN
  • Match partial strings like: SELECT * FROM president WHERE name LIKE '%onal%rump'
  • Learn how CASE statements work, like: SELECT CASE WHEN president_num = 45 THEN 'Yay!' ELSE 'Meh.' END AS pres_score

(Note: those examples are SQL Server...other types like MySQL, PostgreSQL, etc. might be slightly different. Does the job description say something like that, or does it just say "SQL"?)

And here's a list of some SQL interview questions. If it's a job that just requires some SQL knowledge (not "Database Administrator", etc.), then I can't imagine that you'd see anything more difficult than the ones listed here, and probably easier.

https://www.toptal.com/sql/interview-questions

reply or shoot me a message if you see something that doesn't make sense

1
joeblow2020 1 point ago +1 / -0

This is so high quality that I made it my phone's lock screen to give me something to giggle about when the alert comes.

3
joeblow2020 3 points ago +3 / -0

I'll attempt to cover that plot hole with this: REEEEEE how dare you assume xer gender!

1
joeblow2020 1 point ago +1 / -0

I revisited IRC lately and was kind of bummed that I couldn't use a VPN connecting to the popular servers that I remember without some registration baloney. Is there an IRC network with a decent amount of users that doesn't bitch about such things?

1
joeblow2020 1 point ago +2 / -1

Vote these people the fuck OUT...If there's not a Lion to vote for, vote for the Dems, let them burn it down for a few years and start over.

1
joeblow2020 1 point ago +1 / -0

disdain for extermination of

2
joeblow2020 2 points ago +2 / -0

Don't forget Montana (Trump +16) and Alaska (Trump +10). Iowa was Trump +8, even with Dem AG, so they should definitely go. NC has a huge number of good folks that ought to be ready to take the state back from the ever-growing Yankee influx.

2
joeblow2020 2 points ago +2 / -0

List of states that need to step up and the points by which Trump won:

Wyoming - 43+ Kentucky - 26 Idaho - 20+ Montana - 16+ Alaska - 10+ Iowa - 8+ North Carolina - 1.3% (* Do it NC! Don't screw around like last time and be last)

2
joeblow2020 2 points ago +2 / -0

"Infuriating" is the exact word I was looking for. I couldn't even count all the "deboonked" lies that have been told about this!!!

2
joeblow2020 2 points ago +2 / -0

I'm pretty much the same. I had gotten a little too attached to my phone and was getting more concerned with spying/tracking/etc. I did a little research and picked up an old Google Nexus 5 because it's pretty easy to redo it and use Ubuntu Touch on it. It's somewhat slow and Ubuntu Touch is somewhat clunky, but it has everything I need and hasn't really bothered me. After a couple months, I ditched the Nexus and bough a new Pine Phone and am doing the $15/month plan on tello. It only has 2 GB of data a month, but I pretty much only use it for email, directions, and looking at this site and haven't run out. (And apparently you have unlimited "really slow" data if you do run out) Ubuntu Touch also does a pretty cool trick through something it calls "convergence" where you can plug it into an adapter, plug a monitor and keyboard into the adapter, and use it (almost) like a desktop computer. It's not perfect, but it felt good for me to do something to detach myself from big tech.

4
joeblow2020 4 points ago +4 / -0

And ditch android phones! They're good for nothing but harvesting your data without consent. Personally, I'm pretty OK with a Pine64 and Ubuntu Touch.

2
joeblow2020 2 points ago +2 / -0

Shit. Didn't google get youtube-dl kicked off github just a couple weeks ago? Makes a lot more sense in this context.

If you have to youtube, try freetube

3
joeblow2020 3 points ago +3 / -0

Kind of interesting that if you search that PDF for the word "fraud", there are no matches. Not one of the listed companies has anything about fraud prevention, detection, etc. in their bio.

1
joeblow2020 1 point ago +1 / -0

The Biden vote did decrease in those (and other) precincts. At first glance, it made me think that those initial numbers were bogus, but I noticed something else. If you look at the total vote in Chester across time, it stayed nearly the same for Biden. Biden only gained something like 2800 votes up until midnight, and Trump gained something like 44k votes, and actually took the lead! But then, Chester County doesn't seem to have any further data in the files I'm looking at, as if they didn't report data to this after midnight on election night. But according to the current totals, Biden has gained about 76,000 votes since this chart, while Trump only gained about 13,700. Did the Chester County votes counted since midnight on election night really go 85% for Biden? Seems unlike to me. (Also, I've decided that I shouldn't be considering anything in these numbers "bogus"...it's what was reported, and if anything looks off, it needs to be brought to light.) Check out this list of precincts where combined third party candidates got more votes than Trump. 330-1, with third party getting 2? C'mon!

3
joeblow2020 3 points ago +3 / -0

I made a previous post about the data files. There are links to download the raw files and also a .csv with all of them compiled together. Basically, the links came from archive.org snapshots https://thedonald.win/p/11QRoqVBY0/-halp-datapedes-i-have-nytimes-d/

5
joeblow2020 5 points ago +5 / -0

I made a previous post about the data files. There are links to download the raw files and also a .csv with all of them compiled together. Basically, the links came from archive.org snapshots https://thedonald.win/p/11QRoqVBY0/-halp-datapedes-i-have-nytimes-d/

view more: Next ›