diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:51:48 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:51:48 +0000 |
| commit | eccc08693b0498d8e5646cbfb850ad86e1871129 (patch) | |
| tree | afd6a805ee121283c58629201899157bd903b0af /wk7/pset/fiftyville | |
| parent | 0b9a8fe75bbc34d9e932ab89bb47849e4afa6dbd (diff) | |
Tue, May 21, 2024, 1:51 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville')
| -rw-r--r-- | wk7/pset/fiftyville/answers.txt | 2 | ||||
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 24 |
2 files changed, 24 insertions, 2 deletions
diff --git a/wk7/pset/fiftyville/answers.txt b/wk7/pset/fiftyville/answers.txt index c2af8c3..ea760c3 100644 --- a/wk7/pset/fiftyville/answers.txt +++ b/wk7/pset/fiftyville/answers.txt @@ -1,3 +1,3 @@ The THIEF is: Bruce The city the thief ESCAPED TO: New York City -The ACCOMPLICE is: +The ACCOMPLICE is: Robin diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index e7b97e6..b1fe3e5 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -173,6 +173,7 @@ AND id IN ( ; -- BRUCE is the thief +-- Get phone number of accomplice SELECT receiver FROM phone_calls WHERE caller = ( @@ -183,6 +184,27 @@ WHERE caller = ( AND year = 2023 AND month = 7 AND day = 28 -AND duration = 10 +AND duration < 60 ; +-- "(375) 555-8161" +-- Get name of accomplice from their phone number +SELECT name +FROM people +WHERE phone_number = ( + SELECT receiver + FROM phone_calls + WHERE caller = ( + SELECT phone_number + FROM people + WHERE name = "Bruce" + ) + AND year = 2023 + AND month = 7 + AND day = 28 + AND duration < 60 +) +; +-- ROBIN is the accomplice + +-- :3 Miau |