From 5e3da4ab87a795d54c196aff6316040648261231 Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Tue, 21 May 2024 07:37:38 +0000 Subject: Tue, May 21, 2024, 12:37 AM -07:00 --- wk7/pset/fiftyville/log.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'wk7/pset') diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 91bc6bc..dfe36ee 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -77,3 +77,13 @@ AND day = 28 AND atm_location = "Leggett Street" AND transaction_type = "withdraw"; -- account_number:amount | 28500762:48, 28296815:20, 76054385:60, 49610011:50, 16153065:80, 25506511:20, 81061156:30, 26013199:35 + +-- What data does the bank_accounts table have? +.schema bank_accounts +-- account_number, person_id, creation_year + +-- What data does the phone_calls table have? +.schema phone_calls +-- caller, reciever, duration, date + +-- Check for call on 7/28/2023 -- cgit v1.2.3