[Solved]1 Find Names Customers Depositors Accounts Bank Branches Located Salisbury Queries Part Qu Q37256582
My SQL A,B,C
1) Find the names of customers who are depositors and have accounts in all the bank branches located in Salisbury. (For each of the queries that are part of this question, label the query and then refer to the label in later queries, e.g. if one query is labeled Q1 and it is a subquery for another query, you can write the other query as SELECT*FROM X WHERE Y IN (Ql): a) Find all custnames who are depositors. b) Find all actual custname bankname pairs for depositors for bank branches in Salisbury c) Find all the banknames for bank branches in Salisbury Depositor Customer Loan custname custstreet custcity custname acctnum linenum amt bankname Willow North Willow North ntico G-101 G-215 G-102 G-305 G-201 G-217 Johnson C-17 C-23 1000 2000 1500 1500 Smith Downtown Brentwood Nanticoke Downtown Wicomico Somerset Nanticoke Wicomico Wicomico ntico Turner Johnson Jones Lindsay T umet Villiams Wharf Secret Crisfield C-93 Marion 900 1300 C-16 er Jackson Martin Rockfish Salisbury enn er EasternShore Sali 1200 C-8o Johnson Johnson Johnson Sbody Haves G-400 G-402 G-103 G-217 G-105 Secret Baker Branch North Salisbury Account bankname bankcity county assets bankname acctnum balance Downtown Salisbury Brentwood Fruitl and Vienna Wicomico Nithdale Somerset PrincessAn custname linenum Downtown Wicomico Nanticoke G215 G-102 G-305 G-201 G-222 G-217 Jones e SO Somerset Dorchester Brentwood Dorchester Worcester Worcester Downtown EastSide NorthSide C-15 Talbot Worcester Dorchester Cambridge EastSide Salisbury Narth SideSali aston C-93 Williams Adams G-302 G-400 G-402 G-103 Northside G-305 C-23 C-18 C-SO 600 nav 200 Show transcribed image text 1) Find the names of customers who are depositors and have accounts in all the bank branches located in Salisbury. (For each of the queries that are part of this question, label the query and then refer to the label in later queries, e.g. if one query is labeled Q1 and it is a subquery for another query, you can write the other query as SELECT*FROM X WHERE Y IN (Ql): a) Find all custnames who are depositors. b) Find all actual custname bankname pairs for depositors for bank branches in Salisbury c) Find all the banknames for bank branches in Salisbury
Depositor Customer Loan custname custstreet custcity custname acctnum linenum amt bankname Willow North Willow North ntico G-101 G-215 G-102 G-305 G-201 G-217 Johnson C-17 C-23 1000 2000 1500 1500 Smith Downtown Brentwood Nanticoke Downtown Wicomico Somerset Nanticoke Wicomico Wicomico ntico Turner Johnson Jones Lindsay T umet Villiams Wharf Secret Crisfield C-93 Marion 900 1300 C-16 er Jackson Martin Rockfish Salisbury enn er EasternShore Sali 1200 C-8o Johnson Johnson Johnson Sbody Haves G-400 G-402 G-103 G-217 G-105 Secret Baker Branch North Salisbury Account bankname bankcity county assets bankname acctnum balance Downtown Salisbury Brentwood Fruitl and Vienna Wicomico Nithdale Somerset PrincessAn custname linenum Downtown Wicomico Nanticoke G215 G-102 G-305 G-201 G-222 G-217 Jones e SO Somerset Dorchester Brentwood Dorchester Worcester Worcester Downtown EastSide NorthSide C-15 Talbot Worcester Dorchester Cambridge EastSide Salisbury Narth SideSali aston C-93 Williams Adams G-302 G-400 G-402 G-103 Northside G-305 C-23 C-18 C-SO 600 nav 200
Expert Answer
Answer to 1) Find the names of customers who are depositors and have accounts in all the bank branches located in Salisbury. (For … . . .
OR
