Chapter 10 - Summary Report of account and customer trends

Output

Banking Summary

Accounts Overview
Total Number of AccountsEmpty AccountsMaximum BalanceMinimum BalanceAverage Balance
120906,598.24450.0077,856.29
Customer Accounts Overview
CustomerTotal AccountsTotal BalanceAccounts Held
AatoLKYvNhsOlXyl, Onon0
ABCbCSQnvXF, Alexa0
acHhFoAYICJPw, Brooklyn0
adoUuwvoJdrcpupnQT, Ethan1500.00Savings
AebOtDyqgOXrqhVEf, Mark0
aEymYRxTaA, quaker0
Afwmvwyy, Afwmvwyy0
AFzRjgrXQTiQ, Mark0
aGtfdaBDhcFpmlpu, Dghonson1501.00Savings
Ahgmelnn, Ahgmelnn0
ahvAcnfeteergHqOP, Addison0
AiwuJsRCRim, pitfighter0
AkaIDCrTDABtOYbrEQN, Mark0
AKSsEwDaSfrjCM, Brianna0
amEYawNOEWGs, Bryan0
aMSwRkRXcwrvSIRvB, Mark0
anBhUvQDgK, Alex0
aoPZDBEgWB, Mark0
AOzuiaolbvjwoarGC, Mark0
ArCTgLLVmMLPQns, Zoe0
arFjnXjSSkzm, Chloe0
AsMiJnDCEQblzk, Evelyn0
ASXbXPwnjGOhpvd, Genesis0
AukZeDhnfakC, Mark0
AUSUSqjkFZPWHJpHwpX, Kaitlyn0
aWXDZEuyQJkGgsWcc, Mark0
AxczlKOBcw, Mark0
aXtHRgnSVW, Cooper0
AZGjsdUalDfCznNtWl, Gabriella0
bAmPZDTdliLVmesFnQ, Connor0
Bbbcozrg, Bbbcozrg0
bcegovnpsv, bcegovnpsv0
BCtdRkqTeiFpoWBg, Timothy0
bFYoKBKSGP, Mackenzie0
BgLJEugEsYLm, Mark0
BGUzjcdexHfNshWo, Xavier0
BgYrwknHdogFbhysv, Mark0
BhfVZUPptaI, Charlotte0
bIyqDDEPeehK, Sara0
bIyybGzGeYnMSWhxr, Claire0
bJxUMUJCYvTD, Mark0
BLJtMTqHrGUF, varlog0
BLPrcMOjOjTb, David0
bmjPyxoeiNz, yrkhpk0
BMpWyGMdeLe, Isabel0
bnJumGgAFobQ, freeman0
bqqTLlpNQn, Khloe0
bseWORliDHfI, Julia0
BXOWdZlREzWxudC, Henry0
BySVyAhGprDwnBu, Antonio0
BzQOeevQASveQhvYls, dro4er0
cBULYRuoznFVLIRBV, Wyatt0
cCicpAqtMS, Bella0
CCNaFxBnxBYCIC, Mark0
CELlwWvZKaQF, Sara0
CelNFzYhdIKhz, Caleb0
cfrltb, cfrltb0
cFRXygfalXCf, Mark0
CHTsHzkwmTP, Sophie0
cialis 20mg prix en pharmacie paris, cialis 20mg prix en0
cjOQdqRruAqQaDZgIp, Jackson0
ckkOAyAicOLPoTQhlCJ, Elizabeth0
CmDvibRGzbSYFhnGr, Mark0
CMhJIgpgubMZF, deadman0
Cnbhapde, Cnbhapde0
CnSAIdsdUIGr, Vida0
CoqIpeBOoAYjuzZYfs, Mackenzie0
cpgdAVvjGzjdWkN, JimmiNu0
CQPtqOTxHbMeFPVUB, Maria0
cspikp, cspikp0
CstDOehEBGb, Daniel0
cTgYvwttqUoEDfC, Thomas0
cthtcr, cthtcr0
CuJBOnYufxuuOFa, Mark0
CvmkMbLtJHyeLuGGE, Landon0
cvySReEYrKFkEk, Mark0
cXDOodfmkoYYPTOv, Ava0
cXqCGYVBXfIGpFdaPF, Mark0
CzlbcdxtBgKrGbsN, Destiny0
ddpixcub, ddpixcub0
degRavxkIIhAbnS, Mark0
dEtFaaxHDPULJXzW, Michelle0
devXFZtlqVHVVLmdZ, Bryan0
dfTwGgpbHmqoUlH, Brooklyn0
dHzsszZCIDirqrQFW, Mark0
dIWziIZllVkzD, Chase0
dMWZihSDrJSrAqIaN, Mark0
DmZdRCTrAGSkoSmpzlP, Mark0
DPAIeYblHnt, Mia0
dPbBmwPwFToeh, Mark0
DqkehyILkkDpiyCjq, Isaac0
driqzzyAKJtTBjmvPC, Emily0
dryarmaTtzizwq, friend350
DtyiOsFYQSVysGUjBXW, Isaac0
DuCUKpEKkFUOQjtE, Charlotte0
duyGSiikHrKkfbz, Colin0
dvElcoJvvmTPeCabw, Mark0
dvTdyuaGws, Madelyn0
dWorsyYlgdMruwoQn, Curt0
DzJlTWiObf, James0
EBslENMvzvFKZaadEQt, Hannah0
eDDcgKheSyrEuCQb, Dylan0
egFOxwblXzcfYK, Juan0
EGhjScPjQIRvQmhtuqN, Destiny0
eIFCeBdihONoYemyQW, Nicholas0
EIpmsTSMMzhrQSQ, Zoey0
ejfbsymcwj, ejfbsymcwj0
EJpMlTAQTmXj, Gavin0
ELFNfvzEjXjAlkK, Mark0
ELIcNDsiBIRcYHO, Samantha0
ElKSXpNKkLVchFZtGQ, deadman0
EMCGRjsYWexYrHuqHv, Mark0
encEUMScszaie, Brandon0
EoceYrIcUTkOFuu, Bella0
ePMAOMigZearR, odesfoft0
ErQgkQHmwvgkMqdeZ, Mariah0
ertwqxizTROkeytnIOM, Mark0
etBhRqGGSqERbarm, Austin0
ETxDBAXHLDUfa, Caleb0
evHMXqAdmUpxmOEqz, Tony0
EVqQisnKXUYIvaWtcgh, Adam0
EWAXsVJhaUeSr, Stephanie0
eyTCRLpzKosMB, gobiz0
fAiMwabOEXxmUZT, Victoria0
FApKzmHRKhUc, matt0
FbwflokSbH, Gavin0
fBzFrZXtsGvc, Mark0
fcGoEqebkYFQNKF, Sierra0
fflbamCdbVnzzm, Alexis0
FhWlLySksNf, Trinity0
fIZoYmJPZVDCpH, Lily0
fKkfseeVSXQgZnRdVRL, Parker0
FKRbuCjvbNldNUUC, Paige0
fMEaAwwXZFuqMLNfq, Lauren0
FosbQsdMPttALshm, Jordan0
FtkGeSXXAs, Haley0
fuGcpDrRwJI, Garry0
fvYaUAEMGtDE, Vida0
fwdjva, fwdjva0
fwoqigun, fwoqigun0
fxHtKIfBNzatWdyduyw, flyman0
fYStkilcNT, Jackson0
GdQBKizlNlgkAK, freeman0
gEiVHwTZSoeylIAOVxa, Marissa0
GeLNXtHgUKMKfWlO, Brianna0
GFKMkbXWSHlsf, Landon0
gjKWgbDbUOqrJMHKU, Evelyn0
glxjwg, glxjwg0
gosllgx, gosllgx0
gSsjbpVXqtzz, Mark0
Gtdulfxt, Gtdulfxt0
GvjCJFTLTgkLSqGb, Alexandra0
gWvEkNASgosF, Colin0
gYaNfRKapdp, Mark0
GYLKOiMfIjE, Mark0
gYuBCOZFAFyCkAyiH, Payton0
GZDZrhrCaHkK, Mark0
hADmQWRZSdIe, Makayla0
han, hannah0
HCasgemSdmun, Emily0
hcfxzkqaxil, hcfxzkqaxil0
hCLtwLfvVEOX, Mark0
HDyNLCEwHHxg, Leah0
HgErvHroIWy, Sofia0
hgQurYRNTeNiARyfY, cooler1110
hiWoyvCcDolEiTbuTlR, Mark0
hJLYrlgPGg, Austin0
hjoYaxawRFaKf, Addison0
HLkxBVQGdn, Mark0
hMvqijaUAvfZabyHCH, Ashley0
hoJaycRWjewotZDjtSb, Madelyn0
HPYplxqvBrp, Arianna0
HqjUnJXzUUMGOWBIYZ, Mark0
hqqNQysfyM, Taylor0
hsScEAuEscfWiQwM, Rebecca0
hXGYvAaPuURJ, Cooper0
hYegsFlMPX, Mark0
HYJANvfmIlIXvOj, Maria0
HzigNKSNqfwMTA, Mark0
hZYFYoPTpVGUcOoKMiE, Henry0
IcxZdkSPafSXtlrvZGR, Savannah0
IDnElaRAAGnXLxjzG, Joshua0
idqgssPXrwrGeTwvW, Amber0
iDsFwWpZtaNL, Alexander0
IEJevgSXgyySqM, Isaac0
IEXIseljPmpEIgqKFZ, Lauren0
iFODwjfMNNhOnRvNyiN, Mackenzie0
ignMeXrRpQSEEhJeRwn, Savannah0
ihttYzyAAxpJirSzc, Paige0
IhWqrdTWimSiA, fapomvgl0
iizcPsMgXhd, Kaitlyn0
iMvSedluUOWsadgBAAw, Tristan0
INSYXSfUDEZ, Colton0
IOlSDxzECiIJ, Jacob0
IQWRCgIZMVBqXdDv, Zoe0
ITeoojfAVOlBtMwb, Mark0
IUXACKJDLZlTuth, Mark0
iwzWCXGuVpMuTQ, Cameron0
ixtuFwGmsMvyW, Mark0
iZrGpncePKZvCJd, sally0
JaKvBYeCOicnXYZ, Sophia0
jFmnySftGQkpB, Morgan0
jFrKbzzQcLDPe, Tony0
JGWtupTUzUOkhtDa, Sierra0
jIqnMJwwExCdPq, Evelyn0
JNbtSzZpbyHqkDw, Emily0
jODezEMUHKtjQv, Jesse0
jpaoycv, jpaoycv0
JpKKDUFwKLAWoVRzny, Mark0
jpXwFXFCHqZFQSJfBR, Mia0
jqGYbyQwohasxunkdSf, dro4er0
jqKhpLxnpI, Mark0
jsSqohJZlAjL, Mark0
JtvSHblLNshLBhPzWyB, Luis0
JTyTOULHcnrXyfog, Madelyn0
JVVTUoqeSAe, Eric0
JWJEdVGIPZZD, Alexander0
JWuHJjoGGvZbMWhxnzm, Mark0
KADcvdmsQaVrTIe, Destiny0
kaGerykrwG, Jada0
KBaIvjkPvBnGuysQ, Gianna0
KbPBigcWtPRNcq, Ashton0
kelvin, jude15,250.00Savings
KFBQvwAvOZTW, Aidan0
KhqzlufUcNICJV, Devin0
kKgcAYhjNFUKtAr, Carson0
KOvumPNXCsDMCVPRe, Allison0
kpKDFCXvYibLKfYwO, Trinity0
kqeCqLBCLijRcWqPHA, Austin0
kvQiZzSsRvacD, Mark0
kVZxtOSpGgjetfse, Ashley0
KwjSSykeARH, John0
kygEVoWNssSs, Sophia0
KzJQARxNQLEZFerhZ, Morgan0
kZyElSgmAKDyCFZJlMb, James0
KZyrJysvzepYhRQ, Sydney0
LabndDnVOrK, Megan0
lbUCpukQHkYAuNMcm, Wyatt0
LCpjydeFXv, Abigail0
lGjgcosbzTLtrrbCVuP, Juan0
LGxeGqBQpIpqmKtKO, Kaden0
lGZdtbkoghaStJDX, Mark0
lhoDxEjEgeO, Snoopy0
LIQQaTGbAuGa, Xavier0
lITRqTMHIjust, Jackson0
LJctjvAyzfEo, Gavin0
ljYpZtWvmXGsqcho, Emma0
lkCISXbijgkNRLLn, freeman0
LldVwIAtGNpzMOIfe, Mark0
llQycTDVMpDf, Paige0
lMEiZWVBNrRbPqWWwW, Ayden0
lMtPQToUpJ, Mark0
LmVtDUlDgSEDeQgQls, Elizabeth0
lnaAtlvTeL, Jozef0
LrcnZULbbzfAbA, Katelyn0
lRNhpqlySnLzS, Anna0
lRtmmFAEBzHfcJcskTA, Mark0
lTqVRjbKsrUzy, incomeppc0
LtxlBimvWIP, eblanned0
LZrkDfIjjYQFmX, Gabriella0
MAhgiBfagIW, Jada0
MahjMEtlMyM, Mark0
mbbOvEeqXhVxhPmhyfC, Charles0
MbLsRHkulnYzuJZ, Mark0
mDuXjzzGOVHvY, Katelyn0
MDWhSljNoLXM, Mark0
mfzgisndjj, mfzgisndjj0
MmwbVxgVXEUuDTxsnZ, Danielle0
mPqHDtKXIivtffH, Carter0
MQBZeJEKIENBFLBhV, Madison0
mqggRUQevMzJBsw, Victoria0
MTFGlnHCTLRZeUqWN, Mark0
muqKvlVPYwYLu, Vida0
Mvgdhibh, Mvgdhibh0
mvwLOSRiMUbCuH, iudkuwgjt0
MWHaCzFUCF, marcus0
mXerLWqqcAyJdVy, Mark0
MxIxgeZDYHKhsG, William0
MyyJUBWFNEAJDE, Ricky0
mZXbXhYkBVSoLPbWe, Mark0
NAOQBlSbBvhGTugAd, Taylor0
NARfJvFIKJofb, Mark0
nAVPNGvCwVwyt, Brooklyn0
nbrZIYtQPaJoTF, Makayla0
nCIjazJmKxTIZ, Chloe0
nCxpEKjdmGqvh, Mark0
necROEyDHnKhzS, Mark0
negeyrOZvWc, Autumn0
ngbfIiaFNSiuQGnsDEL, Mark0
NJRYeAuJLYzrYUENVTD, Layla0
nkBTwPIGsvwfJA, Carson0
NloWSenmNVefKhpV, Bailey0
Nnamdi, Kojo11,845.00Checking
NPVlJhgwEslnvyLBAYZ, Gracie0
NqCjZwJBnWcQVpjn, Mark0
nQRUYuPyAAEsNzOnd, Mark0
NrFaEdjXgyMsbNiFrqq, Sofia0
Nrozqzag, Nrozqzag0
NShaPOCnAEpEtxvFgs, Michelle0
NTQeFxIedGGFVrVIYU, Aaliyah0
NUYSQlTHFEZfo, Logan0
nWiIYfNjNNZHnKCWIGu, Robert0
nwMKZptIelHvumzZPA, Josiah0
nyBvpzaCRbxKjjV, Mark0
nyMNzmlMrqhibKlzg, heyjew0
NzvUabXQpohr, Mark0
O' Taylor, Ashlie1450.00Checking
O'Taylor, Ashlie0
odMOpkcgaQmmXmVe, Mark0
of Arc, Joan23,699.00Checking,Savings
OgPVpoEPuL, Jonathan0
OhusfzSjnsCImRNR, Mark0
okBBJgRXiLGSv, Mark0
olktdqQlZkEzblwOtLq, Elizabeth0
oLsIcPsifhkKapiTF, Josiah0
onLJwoNguDvZP, Bradley0
onpftpgfVegaid, Ava0
oNPHFxoSIJDb, Justin0
OOGSIkyuZbyioNVe, Mark0
opvsaeh, opvsaeh0
oqmSAxKktqgWkMxnWq, lifestile0
OSBGCVrGylCpAZ, matt11,550.00Checking
oVevjNJJKDPfpNB, Leslie0
OxBQsBxjyFAtFqk, Mark0
OywTmYRXGphLvOqPWZ, Mark0
ozrhccfLyXsicXTDawa, Xavier0
papshomnrw, papshomnrw0
pbqvlObQrnIOOUau, Mark0
pcLhOrjjqDm, Aubrey0
PdEfOSYPCqfUzX, Emily0
pDsEcRzmJdLTZydAnvi, Timothy0
Pdtuksyt, Pdtuksyt0
pEfGokOsDxSEHWNES, Bradley0
pfLhnxZHlNkLBfla, Mariah0
pHdvfnpbNxWggygrxNn, Mark0
PhlOxhuCeqBs, Eva0
pHRlEaNrlcSqeYQEF, Mark0
PmgieaDPufuy, Isabel0
pNMGTyypwSlKNEudewK, Makayla0
PPBcrrmGPGAmnexGhZ, Mark0
ppRWxSohjhFAyic, lifestile0
pPvKjBRfeDBuAUBW, Joseph0
PQdgfqiUpkSCtxe, Bradley0
PQVLrpAKLqTnSyoXtA, Nicholas0
pukpuWNyFiFCpsGBnG, heyjew0
puPSZqIczMTjNBT, Wyatt0
qGbuaRSEynBe, Valeria0
qgEsTJSABiAT, Mark0
qGOAaHSoyCsFu, Maria0
QjmgxtTUsNZXKq, Amber0
QKEukLuSnSTKNrpaMDL, Mark0
QoVRbTeIJmHAtw, Allison0
QujEgmOwLEOixJMVvEH, Mark0
QuMGgLoJCkJBWofjeU, Peyton0
qVzZLKASKLcyT, Brody0
qWDAXcJXflRbteUn, Savannah0
QxftYIAhWtwTERQ, Gracie0
QXvxZSsfAyvotGcA, Carlos0
qXYcQOppQH, Cooper0
qzGYOWSgpLQuq, crazyivan0
qZZaXmbDaCRcMMfOgX, Jason0
RbFAuwReEpIepA, Melissa0
RBOWVwwtaWlwGgcBgEx, Lillian0
rCwgOkkNpj, Melissa0
rFDMxpUfwSpDVtnqrP, Irea0
RgBEEOBKnzz, friend350
rgpUZQhTpUJbC, Avery0
rhfJslekAvEM, Victoria0
rhsVbcJiEWTGNUWaPX, Levi0
RIZmkjKlyk, Liam0
rKIRedJTVW, Mark0
RmdYJwRiAztKH, Gavin0
RmMcYZZJotOgnUgUFce, Mark0
rNZyCrQctZwdcPgfM, Cole0
ROzeigkWfdCOU, Trinity0
Rqfxaqoy, Rqfxaqoy0
rTfZthBuVXisWZJ, Leslie0
RtKJDAGyUe, deadman0
RVUSrdTChujzCDgzk, Brody0
rxCCxyZjsrdKFDgbTS, Faith0
s, s0
SaotkInDxtmpbT, Mark0
sAOYbhdeHHYtnd, Olivia0
scFikAxUlIk, Tyler0
sCihZxOhDSghHKeU, Grace0
SdexpHYxhEZQm, Mark0
sdpQsaXcaISiweCRavm, Jasmine0
SdVLsoBAMAMM, Melissa0
sDWmIsFVWkL, Khloe0
sebwCDdPTq, Camila0
Sedaris, David2914,694.21Checking,Savings
seOIQzjLlRcE, Parker0
sheodkhyJBArxLAqg, Valeria0
SHzUVFeflgoAo, Stephanie0
sKNKorGDdbRSftocrhC, Caroline0
sKsQnlkvJvmaVkOeHR, Marissa0
SmxQhNhDusMHtJN, Mark0
SOiUVoMfkfk, Mark0
sonAwAGqmePaGKU, Destiny0
SovvLkeUeUvGRRGavBQ, Hannah0
sQjSxqVAuXMfVh, Brooklyn0
srbkjvqfwt, srbkjvqfwt0
SsshtrqDOP, Jackson0
SSyBCKClYqpuNpw, mkbhrwzwueu0
STYreaoZolyEyaP, Julian0
SUaMdqjCYJra, Ryan0
svqBZXnsEuciF, Amelia0
sxFbpflUMFbKKopoq, Ariana0
syKflLvrAp, Mark0
SyVGWUJXNdyGxriXgh, Mark0
syYUkVMzpyBEU, Henry0
tadalafil en algerie, tadalafil en algerie0
Taylor, Ashlie0
tbQYPkkMrLwcYob, Evelyn0
tCZqFZHIpZ, heyjew0
TdJhaSPkBSqjyGVa, Mark0
TewqpwLqfC, Mark0
tGttNOXKMMMNTjUBuGu, Andrew0
TMeIxNlymfqmeviLAgV, Jackson0
TPhGwurLmBjs, Danielle0
trnNRJdjOwzFsbsc, Mark0
TsDwKJLSaRqtJRW, Mackenzie0
tsEyFxuXkDYmbJvv, Mark0
tvjWbfcIkGuxTvbwv, Bob0
twjJhGfpogWW, Luke0
TxOgMzlIFrYeVDa, Cameron0
UBjkxPlbEyMCmQptSd, Aaron0
ucLKLCmtqYgh, Levi0
UdFlTwexxJuk, Mark0
ugDcjLFGMv, Luke0
UgznTAJDPHn, Mark0
UhuqIXGRfLgFgkyQLL, Eli0
uIqUhrpeQSiHP, Zachary0
ujEnsYzvzuGFkJ, greenwood0
UjoKuMBaFtIUAC, Mark0
UlwXaSjcaIEkTgpvg, Logan0
UNDhszkeBlQfGZUc, Madelyn0
UnduEqsgjiLfyMr, Mark0
USrMSMlNXvdirUmvWe, Abigail0
usVKDIQJYEERI, Chase0
uwmjclov, uwmjclov0
UXgKdDFmcI, fifa550
uYIDlQQJpwINj, Aidan0
UynqRpKKVAanuUFdnM, Mark0
VaZeplRkiKUKNECzLO, Benjamin0
VBSfmNmoCyh, Benjamin0
vbxRQZTkARdL, Lauren0
vcPdJiXWskrkd, Vanessa0
VdFeTYVWtpg, Zoey0
VDgFPTUmBUG, Dghonson0
VFTeohLtqwKcLGqJ, Mark0
VgAEmzyLlqMqJpUJrNF, Mark0
vHUmbFiLZKL, Brayden0
VIqfavayZuFe, Nicole0
ViqQTOaRHBatoQJaN, Bradley0
vLJXuxuqcOGu, Mark0
VmedWDuoBhgEYlNqoX, JimmiNu0
vNxPtCaHgwvpRnXqkg, Mark0
vogQFLvslR, Lauren0
Vowell, Sarah15,286.24Checking
vprwzYfSyvhK, Audrey0
Vqbxzptc, Vqbxzptc0
vrJJmmqlhUE, Hannah0
VVLshWtfqvMg, Justin0
VvmOnQDHrZ, Snoopy0
VWGKtZggOFAEhPT, Brooklyn0
vxitwYPSnPQxo, Maya0
vzVGrjSQSb, Mark0
WBuhmCmeiTblsHjI, Jessica0
wdrdCTsmHyQqIgBa, Andrew0
wJjVwtqihQzoNbvc, Barbera0
WjmQaNTvIETEvASw, Mary0
WmZaJpCIulRERosi, Carter0
wpbAZZJSjsoozFnU, Sophie0
wrioOyTjRCLFR, Alexa0
wUPMVDPeJhXKbwasMbO, Mia0
WWoLrSAodzWopxwXKKg, Mark0
WWTGpBJOfYxXJ, Justin0
Wxuldvfk, Wxuldvfk0
WYQOCPARjGivmmkml, Jimmi0
wzSGhOKOnaEDHDUfB, Kimberly0
xewwxymqx, xewwxymqx0
xFwpBdZLHYtqKC, unlove0
xKsfqGYFdS, Mark0
XlumEDnuCvvW, Oliver0
XmSYKqoGHpKonSLq, Jenna0
XNNWgjRJxbA, Angelina0
xNrPpPgvFmGZXRIdDf, Ella0
xnwaAAmBbyrFZU, Mark0
XqRpKMRNYzpx, Brian0
xQZCHNNkShzvVJ, Destiny0
xTaEdNbNOnpJ, Evan0
xtICowpXNw, Barry0
XtkfqaJHvxeRnFk, Mark0
xUJEvrUIMkDxVN, Nathan0
xuzSUUgEboPVOD, Gabrielle0
XvFVCsbdrGOipOWxOu, Vanessa0
xwmEKHpJlOEY, Lauren0
XZEfUSZXxEoJegkDGs, Mark0
xZPjHybtMkfvfxJK, Sierra0
yABUSVEblBEFts, Natalie0
YAOAfjMYrrYZnRgWIS, Colin0
YBgtBeiarUORp, Jada0
YCprJCfnvi, Olivia0
YCpXkweclFMi, greenwood0
YDkSGLmKzApJcjLme, Grace0
YeQyxKZxnfyRXqcbOpG, Jack0
YfHznpbzLxWYYFxIAI, Nicholas0
ygGPIYwNvbEmcQ, Mark0
yGnWErnUeiLgMHHkKz, Mark0
YGspcRAAcwuCgcapUP, Lucas0
yhOuFsXpwgmErwWIFSX, Mark0
YIsCNldKtas, Blake0
YIwbjuBJuppzqgWU, Mark0
yjcbxvolgCSUAC, Savannah0
YjtQQYaJlkrgaVrA, john0
YkXNsjRMiTDmFiTuEV, Mark0
YLbZlCjSDwDTZHmwIt, johnansaz0
yLXQVMzcsSHXD, Cameron0
YPnWkCdVdE, Justin0
YrakLbtMwcjXzjLu, Samuel0
YtlNdfMuSTsX, Mark0
yVisKZnayupDlL, Evan0
YwKuztFDKJih, Mark0
yWmsjHiHDdYqCZR, Sean0
YXAYwAkAmHeMf, Jack0
YXsZwTAtNQagJqBN, infest0
ZAIoZBGdFB, Mark0
ZalWAzcykoZmX, Mark0
ZdgCTEMCJpzrnqAGbKa, Logan0
zdnpNEiFmKoCvwbfUJ, Christian0
zeLxTQkDkiLDtAjRamU, Mark0
ZfQrCYIgDFIvcZ, Paige0
zHOsMySyxMfSRAai, Mark0
ZhoXcITswLakJuTlz, Bradley0
zhSTEGJRsEfFA, Mason0
zHTAJaLPBTCqirzCUV, Mark0
zIkjArBkHgcJMgUD, Jessica0
zJAsXHTocl, Mark0
zkalauiCiGXUuvPqg, Julia0
ZKbuAJaMbl, Maya0
ZkMxfSzNtrsQRGa, Jesus0
zlqoAqAEjoPdlRnK, Lucas0
ZNCWzFyVzIt, Rachel1500.00Savings
ZQbRLUsOoOClQJyqe, Peyton0
Zsbbfics, Zsbbfics0
ZSnDMLgrgatXeSYGKm, James0
ZSQhBxXgOeX, Melanie0
zswdeoapg, zswdeoapg0
ZvllrexFAzWVSTub, Patrick0
Zxkimkkt, Zxkimkkt0
ZXLvknBSnI, Olivia0
zYUWDEJWpJBHnrSyCE, Kevin0
zZYvjmrNsUkLmDbyEVw, Michael0
Source
<?php # Script banking overview
 
include (CHAPTER_PATH.'/'.$chapter.'/'.$path.'/includes/header.php');

echo "<div id='content'>";
echo '<h1>Banking Summary</h1>';

// connect to the db
require(CONNECT);

// build query 
$q="SELECT CONCAT_WS(', ',c.last_name,c.first_name) AS Customer, 
COUNT(a.account_id) AS 'Total Accounts', 
FORMAT(SUM(a.balance),2) AS 'Total Balance', 
GROUP_CONCAT(DISTINCT(a.type)) AS 'Accounts Held' 
FROM customers AS c 
LEFT JOIN accounts AS a 
USING(customer_id)
GROUP BY c.last_name, c.first_name ASC";	
// $q = "ERROR";

$qAccounts = "SELECT COUNT(account_id) AS 'Total Number of Accounts',
(SELECT COUNT(account_id) FROM accounts WHERE balance = 0) AS 'Empty Accounts',
FORMAT(MAX(balance),2) AS 'Maximum Balance', 
FORMAT(MIN(balance),2) AS 'Minimum Balance',
FORMAT(AVG(balance),2) AS 'Average Balance'
FROM accounts LIMIT 1";
$rAccounts = mysqli_query($link,$qAccounts);
results_to_table($rAccounts,'Accounts Overview');

// run query
if($r = @mysqli_query ($link, $q)) { 
	// Count the number of returned rows:
	$num = mysqli_num_rows($r);

	if($num > 0) {
		// Print how many users there are:
		// echo "<div class='message'>There are currently $num banking customers.</div>\n";
		//format results in table
		results_to_table($r,'Customer Accounts Overview');
	} else {
		// no results
		echo '<p class="error-message error">There are currently no banking customers.</p>';
	}

	// free result set 
	mysqli_free_result($r);

} else {
	//query unsuccessful
	echo '<h2>Error</h2><p class="error-message error">There was an error accessing the database. Please try again later.</p>';
}
// close db connection 
require(DISCONNECT);

echo "</div>";
include (CHAPTER_PATH.'/'.$chapter.'/'.$path.'/includes/footer.php');
?>