Untitled

python -c "
import psycopg2
from modules.config import get_database_url
conn = psycopg2.connect(get_database_url())
cur = conn.cursor()
cur.execute('''
    SELECT 
        COUNT(DISTINCT rainfall) as r,
        COUNT(DISTINCT soil) as s,
        AVG(rainfall),
        MIN(rainfall),
        MAX(rainfall)
    FROM (
        SELECT rainfall, soil
        FROM barangay_training_data 
        WHERE barangay_id = 6
        ORDER BY id DESC
        LIMIT 730
    ) recent
''')
print(cur.fetchone())
conn.close()
"