How to calculate income tax based on tax slab?

  • sqlguru1day

    SSC Enthusiast

    Points: 152

    Hi guys,

    I am stuck with a task with not getting there?

    I want to calculate income tax based on a taxation system. The thing is for a specific amount say $45000 for example, the tax would be $6895.00 as per below :

    Income Tax Rate                                                                                     Income                                                                Tax

    Income up to $14000, taxed at 10.5%                                                   $14,000.00                                                           $1470.00
    Income over $14000 and up to $48000, taxed at 17.5%                      $31,000.00                                                           $5425.00
    Income over $48000 and up to $70000, taxed at 30%                         $0.00                                                                    $0.00
    Remaining income over $70000, taxed at 33%                                    $0.00                                                                    $0.00

    Total                                                                                                         $45000                                                                 $6895.00

    Can someone please help me on how can I implement it in SQL query? Thanks a lot in advance. 🙂 

  • HappyGeek

    SSCoach

    Points: 18666

    Duplicate post, see How-to-calculate-income-tax-for-a-slab-based-taxation-system

    ...

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply