title: Changing 2 column values in the same table in bigquery
body: <p>I have a table where there is a column with different values like America, South Korea, Japan and so on. I would like to replace the values with America=USA, South Korea=SA, Japan= JP like these. In the same table, there is another column with values like Chittagong, Dhaka, Barisal. I would like to replace the values with Chittagong=CTG, Dhaka=Dhk, Barisal= Ba like these. I would like to use CASE in big query as single query. What would be the code structure?</p>