Replacing null from select result to default value about postgres HOT 8 OPEN

let countDataOverview = 0;
let dash_data_name = ['c_amount', 's_sms', 'new_sub', 'new_unsub', 'm_total_sub', 'm_total_unsub', 'm_total_charge', 'smsc_stat', 'total_sub', 'total_unsub'];
let dash_data = {
    c_amount: 0,
    s_sms: 0,
    new_sub: 0,
    new_unsub: 0,
    m_total_sub: 0,
    m_total_unsub: 0,
    m_total_charge: 0,
    smsc_stat: 0,
    total_sub: 0,
    total_unsub: 0,
}

async function queryOverview(){
    return await sql.begin(sql => [
        /*
        todo -  Fetch different data for overview
       */
        sql`select count(distinct phone)::int from sms.delivery where date = cast(now() as date)`,
        sql`select count(distinct phone)::int from sms.sentsms where date = cast(now() as date)`,
        sql`select count(distinct phone)::int from subscription.sub where subdate = cast(now() as date)`,
        sql`select count(distinct phone)::int from subscription.unsub where unsubdate = cast(now() as date)`,
        sql`select count(phone)::int from subscription.sub where subdate between (SELECT date_trunc('month', now())::date) and (SELECT (date_trunc('month', now()) + interval '1 month - 1 day')::date)`,
        sql`select count(phone)::int from subscription.unsub where unsubdate between (SELECT date_trunc('month', now())::date) and (SELECT (date_trunc('month', now()) + interval '1 month - 1 day')::date)`,
        sql`select sum(charge)::int as count from sms.dailycharge where date between (SELECT date_trunc('month', now())::date) and (SELECT (date_trunc('month', now()) + interval '1 month - 1 day')::date)`,
        sql`select COALESCE(smsc_stat, 0) as count from smsc`,
        sql`select count(phone)::int from subscription.sub`,
        sql`select count(phone)::int from subscription.unsub`,
    ])
}

async function overAll(){
    try {
        overviewQ = await queryOverview();
        weeklyQ = await queryWeeklyCharge();
        overviewQ.map(result => {
            dash_data[dash_data_name[countDataOverview]] = result[0].count;
            countDataOverview++
        })
        console.log(weeklyQ)
        weeklyQ.map(result => {
            weekly_charge[weekly_name[countDataOWeekly]] = result[0];
            countDataOWeekly++
            console.log(result[0].charge)
        })
        sql.close();
    }catch (e) {
        console.log("There is an error reading from database, " + e.message)
    }
}
export const load = async ({locals}) => {
    if(!locals.user) {
        throw redirect(302, '/')
    }
    await overAll()
    return {
        dash_data,
        weekly_charge
    }
}

 sql`select COALESCE(smsc_stat, 0) as count from smsc`

sql`select coalesce((select smsc_stat from smsc), 0) as count`