diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:25:08 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:25:08 +0000 |
| commit | fc4bc8c09dac74c6c93849755d34a45c1401029d (patch) | |
| tree | 7e37c1b1869c82710fe03a5c9216e5f2e4a0e1c8 /wk7/pset/fiftyville/log.sql | |
| parent | 4f321d3218056785e39e51cada5e404e73b9e576 (diff) | |
Tue, May 21, 2024, 1:25 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville/log.sql')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 791bfec..59ba017 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -197,3 +197,11 @@ WHERE phone_number IN ( AND activity LIKE "exit" ) ; + + +SELECT name +FROM people +WHERE phone_number IN ("(130) 555-0289", "(499) 555-9472", "(367) 555-5533", "(609) 555-5876", "(499) 555-9472", "(286) 555-6063", "(770) 555-1861", "(031) 555-6622", "(826) 555-1652", "(338) 555-6650") +AND passport_number IN (7214083635, 1695452385, 5773159633, 1540955065, 8294398571, 1988161715, 9878712108, 8496433585) +AND license_plate IN ("5P2BI95", "94KL13X", "6P58WS2", "4328GD8", "G412CB7", "L93JTIZ", "322W7JE", "0NTHK55") +; |