车船税

去年搞燃油税的时候,还想着车船税是不是可以取消了。因为这个税种本来就有些可有可无,只是因为以前的费用不高,大家可能也没当回事儿,好多人甚至都不记得,年审时才发现这里还要放点儿血。

 

谁曾想,燃油税搞成功了,收费站象征性减了几个,养路费是取消了,可好多地方路桥费又出来了,换个名字而已。这些就不说了,没想到原本不起眼的车船税又站了出来。其实,历史经验早已告诉我们,税种越多,老百姓的负担越重,管理起来越困难,最好的办法就是单一税种。比如以前的农业税,越整越多,越管越乱,最后弄的种地要倒找钱。机动车管理估计也一样,燃油税是最好的办法,其它的税费都应该取消,新能源汽车出来后再想应对办法。

 

这次很难得新华社都连发三文质疑车船税,这让老百姓们似乎又看到了希望。搞车船税的时候,大家都是挺支持的,只是担心车船税收了,其它的费税不停,负担加重,现在看来老百姓的担心成了现实。这两年中国的汽车市场发展的很快,以前想到不敢想的私家家,忽然间就走进了千家万户,这本来是件高兴的事儿。但让老百姓不高兴的是,买了车才发现,养车依然是那么的不容易,而且是越来越不容易,就算你不开停在那里,一年几千块的固定费用也是少不了的。的确,私家车不应该是唐僧肉,谁都想来吃一口。车船税本来就是个奇怪的税种,所谓取之于民,用之于民,那这个税到底是用来做什么的呢?而且,在实行了燃油税之后,应该立即中止该税种才对。所谓什么节能减排,都是晃子,只是在为其存在的合理性找借口。

 

还有前段时间的物业税也是一样,都是让老百姓心存恐慌的东西。根据经验,既然放出风来,就是想试试大家的反应,就像燃油税,说搞也就搞了,大家也只能默默承受了。其实也不敢奢望取消,就像收费站,每天经过时只能在心里骂上几句,又能怎样。还好今年的车船税应该还不会涨,现在去交感觉自己好像还占好大的便宜。

SELECT CASE WHEN grouping(fskgk) = 1 THEN '合计' ELSE fskgk END AS fskgk, SUM(fssjejn) AS fssjejn, SUM(fssjeqn) AS fssjeqn , SUM(fssjedqn) AS fssjedqn, SUM(fhsjn) AS fhsjn , SUM(fhsqn) AS fhsqn, SUM(fhsdqn) AS fhsdqn , round(decode(SUM(fssjeqn), 0, 0, (SUM(fssjejn) - SUM(fssjeqn)) / SUM(fssjeqn)) * 100, 2) AS fcsbjn , round(decode(SUM(fssjedqn), 0, 0, (SUM(fssjeqn) - SUM(fssjedqn)) / SUM(fssjedqn)) * 100, 2) AS fcsbqn , round(decode(SUM(fhsqn), 0, 0, (SUM(fhsjn) - SUM(fhsqn)) / SUM(fhsqn)) * 100, 2) AS hjbjn , round(decode(SUM(fhsdqn), 0, 0, (SUM(fhsqn) - SUM(fhsdqn)) / SUM(fhsdqn)) * 100, 2) AS hjbqn FROM ( SELECT fskgk , round(SUM(fssjejn) / 10000, 2) AS fssjejn , round(SUM(fssjeqn) / 10000, 2) AS fssjeqn , round(SUM(fssjedqn) / 10000, 2) AS fssjedqn , nvl(SUM(fhsjn), 0) AS fhsjn , nvl(SUM(fhsqn), 0) AS fhsqn , nvl(SUM(fhsdqn), 0) AS fhsdqn FROM ( SELECT substr(frkrq, 1, 4) AS fyears, fskgk , SUM(车船税) AS fssjejn, 0 AS fssjeqn, 0 AS fssjedqn FROM zhzs_srfx_ss_all WHERE substr(frkrq, 1, 4)='2023' GROUP BY fskgk, substr(frkrq, 1, 4) UNION ALL SELECT substr(frkrq, 1, 4)AS fyears, fskgk , 0 AS fssjejn, SUM(车船税) AS fssjeqn, 0 AS fssjedqn FROM zhzs_srfx_ss_all WHERE substr(frkrq, 1, 4)='2022' GROUP BY fskgk, substr(frkrq, 1, 4) UNION ALL SELECT substr(frkrq, 1, 4)AS fyears, fskgk , 0 AS fssjejn, 0 AS fssjeqn, SUM(车船税) AS fssjedqn FROM zhzs_srfx_ss_all WHERE substr(frkrq, 1, 4)='2021' GROUP BY fskgk, substr(frkrq, 1, 4) ) a left JOIN ( SELECT substr(fcldjsj, 1, 4) AS years, fssqx , fclspswl AS fhsjn, '0' AS fhsqn, '0' AS fhsdqn FROM zhzs_bill_clspdjxx WHERE substr(fcldjsj, 1, 4) = '2023' GROUP BY substr(fcldjsj, 1, 4), fssqx, fclspswl UNION ALL SELECT substr(fcldjsj, 1, 4) AS years, fssqx , '0' AS fhsjn, fclspswl AS fhsqn, '0' AS fhsdqn FROM zhzs_bill_clspdjxx WHERE substr(fcldjsj, 1, 4) = '2022' GROUP BY substr(fcldjsj, 1, 4), fssqx, fclspswl UNION ALL SELECT substr(fcldjsj, 1, 4) AS years, fssqx , '0' AS fhsjn, '0' AS fhsqn, fclspswl AS fhsdqn FROM zhzs_bill_clspdjxx WHERE substr(fcldjsj, 1, 4) = '2021' GROUP BY substr(fcldjsj, 1, 4), fssqx, fclspswl ) b ON a.fyears = b.years and a.fskgk = b.fssqx GROUP BY fskgk ) GROUP BY ROLLUP (fskgk) ORDER BY CASE WHEN fskgk = '合计' THEN 1 ELSE 2 END
06-03
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

极客行天下

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值