Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What are the account ID, customer ID, branch name, transactions (date, type, amount) for transactions on accounts that were opened after 2007-06-30? Create a multiple
What are the account ID, customer ID, branch name, transactions (date, type, amount) for transactions on accounts that were opened after 2007-06-30? Create a multiple table advanced SQL SELECT query that can solve this question. Pictures of the database can be found below.
Query 2 accounts X employees * customers x Limit to 1000 rows 1 . SELECT * FROM aasrutg1_mi557.accounts; transactions X branches departments products x QUE 100% 1:1 Filter Rows: Search Edit: B Export/Import: Po Result Grid 1 account_id cust_id open_emp_id 1 1 10 9 2 3 4 5 6 7 8 9 product_id CHK SAV CHK SAV CHK "" SAV . CHK "" SAV LOC MM MM 1 2 3 4 4 5 6 7 8 9 6 7 available_balance 1000.00 4598.00 3000.00 5433.00 158.00 10000.00 www. 567.00 orice 3450.00 12500.00 50000.00 35000.00 www.co 5487.09 10000.00 5000.00 3487.19 7 8 8 open_date branch_id 2007-01-01 1 2007-10-05 1 2009-04-25 1 2009-05-05 3 2009-07-10 2 2009-12-31 1 2010-01-01 1 w 2010-03-21 2 w 2010-04-13 1 2010-06-30 1 2010-08-25 1 2010-11-03 2 sum. 2010-12-01 1 2010-12-07 2 2010-12-10 3 NULL 9 10 9 10 11 12 6 MM 10 11 13 7 8 9 14 SAV CHK SAV 12 13 15 10 NULL NULL NULL NULL NULL NULL transactions branches x departments products x + 2 Query 2 x accounts X employees x customers X 8 Limit to 1000 rows SELECT * FROM aasrutg1_mi557. employees;|| emp_id 100% 40:1 Result Grid Filter Rows: Q Search Edit: 2 - Export/Import: first_name last_name title start_date dept_id branch_id superior_emp... Michael Smith CEO 2005-01-01 3 1 NULL 2 Susan Barker Vice President 2006-09-12 3 1 1 3 Robert Tyler Secretary 2005-01-01 3 1 2 - 4 Susan Hawthorne Operations Manager 2006-04-24 1 1 2 5 John Gooding Loan Manager 2007-11-14 2 1 2 6 Helen Fleming Head Teller 2008-03-17 1 2 4 7 Chris Tucker Teller 2008-09-15 1 1 4 8 Sarah Parker Teller 2006-12-02 1 2 6 9 Jane Grossman Teller Toll 2006-05-03 1 3 10 10 Paula Roberts Head Teller 2006-07-27 1 3 4 NULL NULL NULL NULL NULL NULL NULL NULL transactions X branches x departments x products x Query 2 x accounts X employees X customers X 310090 x Limit to 1000 rows 1. SELECT * FROM aasrutg1_mi557.customers; 100% 1:1 Result Grid cust_id fed_id 111-11-1111 2 222-22-2222 3 333-33-3333 4 444-44-4444 5 555-55-5555 . 6 666-66-6666 - 7 777-77-7777 200 00 00 8 BBB-88-8888 9 999-99-9999 10 101-10-1010 11 110-11-1100 12 120-12-1212 13 130-13-1313 NULL NULL Filter Rows: Q Search Edit: B Export/Import: A cust_type_cd address city state zipcode 1 4 Main Street Lynnfield MA 01904 1 5 Park Ave Woburn MA 01801 1 12 Lake Ave Qunicy MA 02169 w? 8 School Lane Waltham MA 02451 ' 7 Main Street Salem NH 03073 22 School Lane wa Waltham MA 02451 warna w 51 Cinder Dr Wilmingt... MA 01867 1 10 Main Street Salem NH 03073 1 55 College Ave ma Newton MA 02456 HEM B 15 Main Street Salem NH 03073 B 121 Cinder Dr Wilmingt... MA 01867 B 17 Main Street Salem NH 03073 B 27 Lake Ave Quincy MA 02169 NULL NULL NULL NULL NULL + Query 2 X accounts x employees x customers X x x Limit to 1000 rows 1 SELECT * FROM aasrutg1_mi557.transactions; transactions * * branches * departments x products * . 100% 1:1 Edit: Export/Import: Result Grid 1 Filter Rows: Q Search txn_id txn_date account_id txn_type_cd amount 1 2010-02-22 1 credit 1000.00 2 2010-02-23 2 credit 525.75 3 2010-02-24 1 debit 100.00 w 4 2010-02-24 3 credit w 55.00 5 2010-02-25 1 debit 50.00 . 6 2010-02-25 3 debit 25.00 7 2010-02-25 2 credit 125.37 8 2010-02-26 3 debit 10.00 9 2010-02-27 1 credit 75.00 NULL NULL NULL NULL NULL X departments x products X Query 2 accountsx employees X customers X x Limit to 1000 rows 1 SELECT * FROM aasrutg1_mi557.branches; transactions X branches X 0.17 100% 1:1 Result Grid Filter Rows: Search Edit: 45 Export/Import: Po branch_id 2 branch_name Woburn Salem Quincy NULL 3 NULL transactions X branches X departments X products X Query 2 X accounts X employees X customers X x Limit to 1000 rows SELECT * FROM aasrutg1_mi557.departments; 100% 1:1 Result Grid Filter Rows: Q Search Edit: Export/Import: dept_id dept_name Operations 2 Loans 3 Administration NULL NULL X transactions x branches X departments x products X Query 2. accounts X employees x customers Limit to 1000 rows 1 SELECT * FROM aasrutg1_mi557.products; 100% 1:1 Result Grid Q Search Edit: Export/Import: product_id CHK LOC MM SAV NULL Filter Rows: product_name Checking Line of Credit Money Market Savings NULL
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started