Are the names and email addresses in the sample data real? They seem auto generated but the domains are real providers like Hotmail, Gmail, and Outlook.
I searched a few emails in some local copies of data breaches and found real results
Show HN: SQL Police Department – Learn SQL while solving crimes
11–20 of 91 posts
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#12Are the names and email addresses in the sample data real? They seem auto generated but the domains are real providers like Hotmail, Gmail, and Outlook.
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.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#13This reminds me of the SQL Murder Mystery: https://mystery.knightlab.com/
This was certainly an inspiration.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#14Worth considering capturing the keyboard input. I instinctively hit "delete" partway through to delete something I had clicked on and it took me back to HN and I lost my progress.
Good call. I will.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#15>"A mailing list of an illegal online service was sent to the SQLPD hot-line. Please submit all records email addresses' details. Please make sure there are no duplicates."
typo
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#16I literally can't get past the first level and I have no idea why.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#17[deleted]
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#18I literally can't get past the first level and I have no idea why.
click on GUI.
click SELECT
click *
click FROM
click mailing_list
click run
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#19Nice 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.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#20I literally can't get past the first level and I have no idea why.
click on GUI. click SELECT click * click FROM click mailing_list click run
I had one before that, asking about all member data from a darknet list. It seemed logical that select * from members would be the answer based, but I couldn't get it to accept no matter how many times I tried. Kept saying failed to fetch after run. I closed and reopened the browser, tried again, and it worked on the first attempt.