SQL Murder Mystery

#1

Post by kickscondor » Mon, Dec 16, 2019, 12:38 AM UTC

SQL Murder Mystery
mystery.knightlab.com

Re: SQL Murder Mystery

#2

Post by tunesmith » Mon, Dec 16, 2019, 12:51 AM UTC

It looks like this should help:

https://github.com/NUKnightLab/sql-mysteries/blob/master/pro...

Re: SQL Murder Mystery

#3

Post by Waterluvian » Mon, Dec 16, 2019, 1:02 AM UTC

There is a Lot of crime in SQL City. I wonder if ORMTown is just as bad. ;)

Re: SQL Murder Mystery

#4

Post by kroltan » Mon, Dec 16, 2019, 1:04 AM UTC

Waterluvian wrote: post #3

There is a Lot of crime in SQL City. I wonder if ORMTown is just as bad. ;)

Actually, the murder victims are all ORM users.

Re: SQL Murder Mystery

#5

Post by rozab » Mon, Dec 16, 2019, 1:22 AM UTC

tunesmith wrote: post #2

It looks like this should help: https://github.com/NUKnightLab/sql-mysteries/blob/master/pro...

Thank you. Perhaps the OP should link to https://github.com/NUKnightLab/sql-mysteries ?

Re: SQL Murder Mystery

#6

Post by whidden » Mon, Dec 16, 2019, 1:23 AM UTC

kroltan wrote: post #4

Waterluvian wrote: post #3

There is a Lot of crime in SQL City. I wonder if ORMTown is just as bad. ;)

Actually, the murder victims are all ORM users.

well said.

Re: SQL Murder Mystery

#7

Post by tim-- » Mon, Dec 16, 2019, 1:31 AM UTC

Very smart! I love how the `solution` table works to add some additional fun to the challenge.

Re: SQL Murder Mystery

#8

Post by smitty1e » Mon, Dec 16, 2019, 1:40 AM UTC

Waterluvian wrote: post #3

There is a Lot of crime in SQL City. I wonder if ORMTown is just as bad. ;)

"We built SQL City on GRANT and ROLE."

Re: SQL Murder Mystery

#9

Post by ihunter2839 » Mon, Dec 16, 2019, 1:54 AM UTC

I played along on the web based ui but for the life of me can't figure out how to check my solution? I see that there is an insert statement given on the github page but I get a 'Statement must be a SELECT' error when I try to execute it. What am I missing?

Re: SQL Murder Mystery

#10

Post by kevindong » Mon, Dec 16, 2019, 1:58 AM UTC

ihunter2839 wrote: post #9

I played along on the web based ui but for the life of me can't figure out how to check my solution? I see that there is an insert statement given on the github page but I get a 'Statement must be a SELECT' error when I try to execute it. What am I missing?

This link is better: http://mystery.knightlab.com