--UTILITIES
SELECT COUNT(*) FROM transazioni_2016;--155220401 (no prelievi)
SELECT COUNT(*) FROM transazioni_0116_1216_in_anag;--154236074
SELECT COUNT(*) FROM clienti_0116_1216_12mm;--682361
SELECT COUNT(*) FROM transazioni_0116_1216_in_anag_12mm;--91579304

SELECT COUNT(*) FROM transazioni_1116_1017;--190153271 (no prelievi)
SELECT COUNT(*) FROM transazioni_1116_1017_in_anag;--186334932
SELECT COUNT(*) FROM clienti_1116_1017_12mm;--1033177
SELECT COUNT(*) FROM transazioni_1116_1017_in_anag_12mm;--153176665
--TABELLE CHURN

SELECT COUNT(*) FROM tabella_training_0116_1216;--682361
SELECT COUNT(*) FROM tabella_recall_1116_1017;--1033079

--PREDICTIONS PER ROC
SELECT COUNT(*) FROM iccrea_tm.churn_0218;--1033079


--ANALISI
SELECT "0116_1216",max(amm_u_tra), max(recency), MIN(dt_1_ric), MAX(dt_1_ric),
MAX(dt_u_sca), min(eta), max(eta), max(max_amm), avg(perc_acq_i_o), avg(post_pre_ratio), max(perc_cre),max(perc_deb),max(perc_pre),max(avg_tra_acq),avg(stdev_trans),min(tot_trans),min(tot_transaz),avg(avg_trans)
FROM tabella_training_0116_1216
UNION
SELECT "1116_1017", max(amm_u_tra), max(recency), MIN(dt_1_ric), MAX(dt_1_ric),
MAX(dt_u_sca), min(eta), max(eta), max(max_amm), avg(perc_acq_i_o), avg(post_pre_ratio), max(perc_cre),max(perc_deb),max(perc_pre),max(avg_tra_acq),avg(stdev_trans),min(tot_trans),min(tot_transaz),avg(avg_trans)
FROM tabella_recall_1116_1017;