Question

MySQL

Customer Loan Depositor custname custstreet custcity banknaine linemu amt amt custname acctnum Jones Smith Hayes Curry Lindsay Tumer Williams Adams Johnson Glenn Brooks Green Baker Smythe Sbody Willow North Willow North Main Wharf Main Spring Ocean Jackson Eastern Shore Martin Bay Rockfish North Quantico Salisbury Quantico Salisbury Berlin Secretary Crisfield Marion O C OP Salisbury Secretary OC Salisbury Salisbury Downtown Brentwood Nanticoke Downtown Wicomico Somerset Nanticoke C-17 C-23 C-15 C-14 C-93 C-11 C-16 1000 2000 1 500 1 500 500 900 1300 Johnson | G-101 Smith G-215 Hayes G-102 Turner G-305 Sbody G-217 Johnson1G-201 Jones G-217 Lindsay G-222 Baker TG-301 Baker G-302 Johnson G-400 Johnson G-402 Johnson G-102 1 Branch banknaine bankcity county assets Borrower Account WI9 WI 2.1 DO bankname acctnum balance linenuun 04 500 C-17 1 Downtown Wicomico Nanooke Somerset 700 400 Downtown Brentwood Nanticoke Wicomico Somerset Talbot Worcester Dorchester East Side North Side Salisbury Fruitland Vienna Nithdale PrincessAnne Easton L Berlin Cambn dge Salisbury Salisbury 03 37 350 Dorchester G-101 6-215 G-102 6.305 G-201 G-222 G-217 G-301 G-302 G-400 G.402 G-103 TA WO DO WI WI 7.1 Brentwood Jones Smith Hayes Jackson deson Curry Smith Williams Adams Smythe C-15 C-14 C-93 C-11 C-17 0-16 C-23 900 700 750 200 6 00 2 00 6 00 300 Dorchester Worcester Worcester Downtown Eastside Northaide

Answer 1

G-215 is account number having balance more than avg balance and he also lives in Salisbury

Select a Aconos from customer C, Accocent a, Balence B Where 13. bank city2 c.custcity AND c.custcity - Salisbury AND. abal > Select Avg (a-balanie) I from Account a /

Tqs for ur patience

All the best

Any queries plzz comment