41–50 of 91 posts
There's no declaration of what attribute should be used for considering distinct users. After guessing it gave a hint to the effect of "there are duplicate Given Name values". This is rather counter intuitive since many people share a given name.
Here are some other SQL Learning resources I have collected in my note taking TiddlyWiki (mostly from HN itself). Interactive SQL Tutorials : ▪ Chartio Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/ ▪ Select STAR SQL - https://selectstarsql.com/ ▪ SQL Bolt - Learn SQL with simple, interactive exercises - https://sqlbolt.com/ ▪ SQL Window functions - https://www.windowfunctions.com/ ▪ PostgreSQL…
This reminds me of the SQL Murder Mystery: https://mystery.knightlab.com/
It's great! I would buy a licence but I don't know how many cases do you have altogether?
I plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.
And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
Nice concept but I really hate clicking on the buttons to form my statements... Is it possible to allow typing? Also, not ending my statement with a semicolon feels incomplete.
Here are some other SQL Learning resources I have collected in my note taking TiddlyWiki (mostly from HN itself). Interactive SQL Tutorials : ▪ Chartio Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/ ▪ Select STAR SQL - https://selectstarsql.com/ ▪ SQL Bolt - Learn SQL with simple, interactive exercises - https://sqlbolt.com/ ▪ SQL Window functions - https://www.windowfunctions.com/ ▪ PostgreSQL…
Great collection thanks! Has anyone used them or have any comment on the difficulty of the sources above?
Perhaps I'm missing something but I can't seem to find what I get for my money, what concepts and commands are covered? How many "cases" are there?
And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
Earlier quoted context omitted.
I agree. I work in Microsoft's SQL Server (incl. variations, e.g. Azure SQL DW) quite a bit. Based on my experience, I am the only person using semicolons in T-SQL.
I always try to use them. It's going to be mandatory says MS: "Although the semicolon isn't required for most statements in this version of SQL Server, it will be required in a future version."
Earlier quoted context omitted.
Everything is randomised, nothing is based real data. It's auto generated from popular first names, last names, changing patterns and random years or numbers attached at the end. Domains are real, but randomised as well.
It's kinda risky in my opinion. I just checked a few of the addresses (mostly the one's without any numbers at the end), some of them do actually belong to real people.
Cool concept but the license seems kind of weird to me. 20 bucks for six months? Will anything change in that time? You might want to add a bit of info on what the license gets you.
The 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.