我提供给你一段sql，你需要修改一下，要求是所有关于查询el_requirement_apply和el_comp_info表的语句均需要增加del_flag = '0'的条件，修改完成后你需要将完整的代码返回给我，完整的sql如下： SELECT gen_random_uuid() AS id,
(( SELECT count(1) AS count
FROM el_comp_info
WHERE ((substr((el_comp_info.unified_code)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_comp_info.unified_code)::text = (feiminying.uniscid)::text)))) AND ((el_comp_info.del_flag)::text = '0'::text) AND ((el_comp_info.audit_status)::text = 'AUDITED'::text))))::numeric AS registeredenterprisenum,
COALESCE(( SELECT count(1) AS count
FROM el_granting_credit,
el_financial_institution,
el_requirement_apply
WHERE (((el_requirement_apply.id)::text = (el_granting_credit.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_granting_credit.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS creditenterprisenum,
COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.user_id)::text = (el_loan_grant.create_by)::text))), (0)::bigint) AS loanenterprisenum,
COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.user_id)::text = (el_loan_grant.create_by)::text))), (0)::bigint) AS loanmicroenterprisenum,
COALESCE(( SELECT sum(el_granting_credit.granting_amount) AS sum
FROM el_granting_credit,
el_financial_institution,
el_requirement_apply
WHERE (((el_requirement_apply.id)::text = (el_granting_credit.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_granting_credit.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS creditamount,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_requirement_apply,
el_financial_institution
WHERE (((el_requirement_apply.id)::text = (el_loan_grant.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS loanamount,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_requirement_apply,
el_financial_institution
WHERE (((el_requirement_apply.id)::text = (el_loan_grant.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS inclusivemicroenterpriseloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_requirement_apply,
el_financial_institution
WHERE (((el_requirement_apply.id)::text = (el_loan_grant.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS loannum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS creditloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS creditloannum,
COALESCE(( SELECT sum(el_requirement_info.amount) AS sum
FROM el_requirement_info,
el_requirement_apply,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text))), (0)::numeric) AS financingneedsamount,
COALESCE(( SELECT count(1) AS count
FROM el_requirement_info,
el_requirement_apply,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_financial_institution.id)::text = (el_requirement_apply.institution_id)::text))), (0)::bigint) AS financingneedsnum,
COALESCE(( SELECT trunc(avg(to_number((el_loan_grant.loan_rate)::text, '0.00'::text)), 2) AS trunc
FROM el_loan_grant,
el_requirement_apply
WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))))), (0)::numeric) AS averagelendingrate,
COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.user_id)::text = (el_loan_grant.create_by)::text))), (0)::bigint) AS monthloanenterprisenum,
COALESCE(( SELECT count(1) AS count
FROM el_user_info rr,
el_financial_institution tt
WHERE (((rr.id)::text = (tt.user_id)::text) AND ((rr.user_type)::text = 'FI'::text) AND ((tt.parent_id)::text <> '-1'::text))), (0)::bigint) AS settledinfinancialinstitutionnum,
COALESCE(( SELECT count(1) AS count
FROM el_financial_product,
el_financial_institution
WHERE ((el_financial_product.create_by)::text = (el_financial_institution.user_id)::text)), (0)::bigint) AS financialproductsnum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_financial_institution,
el_requirement_apply
WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS monthloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_financial_institution,
el_requirement_apply
WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS monthloannum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS monthcreditloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS monthcreditloannum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_requirement_apply,
el_financial_institution
WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS monthinclusivemicroenterpriseloanamount,
COALESCE(( SELECT sum(el_requirement_info.amount) AS sum
FROM el_requirement_info,
el_requirement_apply,
el_financial_institution
WHERE ((substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text) AND (to_char(el_requirement_info.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::numeric) AS monthfinancingneedsamount,
COALESCE(( SELECT count(1) AS count
FROM el_requirement_info,
el_requirement_apply,
el_financial_institution
WHERE ((substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1
from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying
WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text) AND (to_char(el_requirement_info.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::bigint) AS monthfinancingneedsnum,
'2023-06-20 08:00:00'::text AS statisticsbegintime,
now() AS statisticsendtime
本文主要介绍了...（由于未提供具体博客内容，无法生成精确摘要）。
扫一扫
4万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
