XGsp1gVx

1SELECT 
2
3PCR.name,
4PCR.repdte as Quarter, 
5PCR.idlncorr as NetLoansAndLeasesToCoreDeposits,
6CAST(LD.IDdeplam as int) as DepositAccounts$GreaterThan$250k
7from All_Reports_20180630_Performance_and_Condition_Ratios as PCR 
8join 
9'All_Reports_20180630_Deposits_Based_on_the_$250,000_Reporting_Threshold' 
10 as LD on PCR.cert = LD.cert
11UNION ALL
12SELECT
13PCR.name, 
14PCR.repdte as Quarter,
15PCR.idlncorr as NetLoansAndLeasesToCoreDeposits,
16CAST(LD.IDdeplam as int) as DepositAccounts$GreaterThan$250k
17FROM All_Reports_20180331_Performance_and_Condition_Ratios as PCR
18JOIN 
19'All_Reports_20180331_Deposits_Based_on_the_$250,000_Reporting_Threshold' 
20 as LD on PCR.cert = LD.cert
21	
22Quarter   
2303/31/2018
24	
25ReportDate
26  2009q1
27	
28substr(PCR.repdte,7,4)||'q'||CAST(1+((substr(PCR.repdte,1,2)-1) / 3) AS INTEGER)
29	
30DROP TABLE IF EXISTS PCR;
31CREATE TABLE IF NOT EXISTS PCR (repdte);
32INSERT INTO PCR VALUES('01/31/2009'),('02/31/2009'),('03/31/2009'),('04/31/2009'),('05/31/2009'),('06/31/2009'),('07/31/2009'),('08/31/2009'),('09/31/2009'),('10/31/2009'),('11/31/2009'),('12/31/2009');
33
34SELECT PCR.repdte,
35    substr(PCR.repdte,7,4)||'q'||CAST(1+((substr(PCR.repdte,1,2)-1) / 3) AS INTEGER) FROM PCR;