Using the brewbeans database:

declare a bind variable called g_state that takes as input the abbreviation of the state. if the state value is VA then the tax is 4%, if the state value is NC then the tax is 2%, and if the state value is NY then the tax value is 6%. Write the code using case statements and test the code and check what happens if you enter a state value other than the three stated in this question. Rectify the error through exception handling