Sql hints

Just some sql sample queries which is needed for some kind of analytics:

WITH t_tbl AS (
    select ft.code, b."name", ft.amount, to_char(transfer_date,'yyyy-mm-dd') as ft_date from funer ft 
    left join ben b on ft.code = b.code 
    where date_trunc('day', ft.date) >= '2023-01-01' and ft.status in ('PROCESSED') 
)
SELECT code, "name", sum(amount) FROM t_tbl fts group by fts.code, fts."name";

SELECT id, inn FROM fns_msp.msp_registry group by (id) having count(inn) > 1;

Another sql example with WITH clause

WITH c_t_table as (
    select * from c where (c.code, c.id) in (
        select cc.code, max(cc.id) from cc 
        where cc.code in (select baa.code from baa 
            where baa.c_code in ('CODE') and cc."type" = 'TYPE' or cc."type" = 'TYPE')
        group by cc.code
        )
    )
select ct.name as name, ct.tin as tin, baa.* from baa 
left join c_t_table ct on baa.code = ct.code
where baa.c_code in ('CODE');