Transforming Data

In this hands-on Lab you have been tasked with transforming a dataset in a PostgreSQL database. After connecting to the database named demo as the postgres user, you will need to complete the following steps to accomplish this:

• Cleanse the data by truncating the department column of the users table to 3 characters.
• Append the expense code value to the department column of the users table.
• Sum expense amounts from expenses table for each department.