[Solved]Customer Depositor Loan Custname Custstreet Custcity Banknamelinenumamtuname Acctnum Jones Q37205795
SQL
Customer Depositor Loan custname custstreet custcity banknamelinenumamtuname acctnum Jones Qumtico John son G-101 C-17 C-23 1000 Smith G-215 G-102 Hayes Quantico Brentwood Nanticoke Downtown Wicomico Hayes Bealin Secretary Crisfield Lindsay Main Wharf C-14 C-93 C-11 C-16 C-18 C-80 1500 Johnson G-201 Turner illiams G-222 G-301 G-302 G-400 Spring Lindsay Baker Baker Johnson Oc OP ohnson 1300 Nanticoke Wicomico ‘en 1200 Wicomico a Jackson Glenn Brooks Green Martin Secretary G-402 G-103 Smythe Rockfish Salisbury Salisbury Branch Sbody G-21 Account bankname bankeity county assets Borrower bankname asaum balance Donatown Salisbury Downtown G-101 500 BrentwoodFruit and 21 ustname linenum Wicomico G-213 Somerset G-305 Brentwood C-23 Smith 400 900 50 一□Dorchester G.102 60 G-201 G-222 Berlin orcester ㄧㄒㄧ-Curry -Do dan bridge C-11 C-17 C-16 C-23 C-18 80 Smith Williams Dorchester -G-217- EastSide SalisburyW Worcester G.302600 North Side Salisbury WI G-400 G-402 Downtowrn 600 EastSide North Side G-103 1 Find the o bankname pairs but not in the actual custname bankname pairs for banlk e custnames of the custname ban kname pairs that are in all possible custname g) Answer the original query, i.e. find the names of customers who are depositors and who have accounts in the all 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 CQ1);) Show transcribed image text Customer Depositor Loan custname custstreet custcity banknamelinenumamtuname acctnum Jones Qumtico John son G-101 C-17 C-23 1000 Smith G-215 G-102 Hayes Quantico Brentwood Nanticoke Downtown Wicomico Hayes Bealin Secretary Crisfield Lindsay Main Wharf C-14 C-93 C-11 C-16 C-18 C-80 1500 Johnson G-201 Turner illiams G-222 G-301 G-302 G-400 Spring Lindsay Baker Baker Johnson Oc OP ohnson 1300 Nanticoke Wicomico ‘en 1200 Wicomico a Jackson Glenn Brooks Green Martin Secretary G-402 G-103 Smythe Rockfish Salisbury Salisbury Branch Sbody G-21 Account bankname bankeity county assets Borrower bankname asaum balance Donatown Salisbury Downtown G-101 500 BrentwoodFruit and 21 ustname linenum Wicomico G-213 Somerset G-305 Brentwood C-23 Smith 400 900 50 一□Dorchester G.102 60 G-201 G-222 Berlin orcester ㄧㄒㄧ-Curry -Do dan bridge C-11 C-17 C-16 C-23 C-18 80 Smith Williams Dorchester -G-217- EastSide SalisburyW Worcester G.302600 North Side Salisbury WI G-400 G-402 Downtowrn 600 EastSide North Side G-103
1 Find the o bankname pairs but not in the actual custname bankname pairs for banlk e custnames of the custname ban kname pairs that are in all possible custname g) Answer the original query, i.e. find the names of customers who are depositors and who have accounts in the all 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 CQ1);)
Expert Answer
Answer to Customer Depositor Loan custname custstreet custcity banknamelinenumamtuname acctnum Jones Qumtico John son G-101 C-17 C… . . .
OR
