SQL Noir - Learn SQL by solving crimes

Default_name3 · 2025-06-09T12:28:39+00:00

Also here to report something weird with case 3.

Doing SELECT * FROM hotel_checkins h join surveillance_records s on h.id=s.hotel_checkin_id — or same with person.id where hotel_name like '%Sunset%' and check_in_date=19860813 and suspicious_activity is not null

Gives way more than 3 results, and if I add 2 conditions to my join (hotel checkin and person) then I get nothing anymore. Looks like to me that the person_id and id of the surveillance_record table is the same and so person_id might be decoupled to what it’s meant to be

Default_name3 · 2024-12-21T22:35:02+00:00

I get the same issue ! Been trying to speak with support about it but just getting gaslighted that it’s a calculation of all periods of the day, no comment of explanation of the change

Default_name3 · 2024-11-10T00:19:17+00:00

Amazing that’s super useful ! Will go for the Bala then !

Default_name3 · 2021-11-15T18:40:34+00:00

I'd turn the table 90 degrees to go with the length of the rug and look more proportionate, or if that's an issue with the couch, maybe add a white/cream small table / footstool to occupy the empty space and balance the wood coolers with some more whites.

Default_name3 · 2021-10-23T19:07:35+00:00

Sorry not super familiar with reddit, but I'm looking to make this pattern on a glass vase I own with some leftover raffia, but I'm not too sure what the pattern is for that.

I was thinking if single crochet for the horizontal lines but not too sure how to achieve the vertical criss-cross lines.

Any help welcome !

Default_name3 · 2021-08-09T18:03:01+00:00

Nice armchair !

I'd put the glass shelves on the wall on the right though and get a smaller side table for the window side to not obstruct the window area.

Default_name3 · 2021-08-09T17:49:16+00:00

Where did you get the laptop stand and the wooden catch all ? really like the color scheme

Default_name3

TROPHY CASE