Task: Increment a Value in PostgreSQL
Task: Increment a Value in PostgreSQL: a task in Terminal-Lego-15k (Harbor dataset). Create a PostgreSQL database setup and demonstrate how to increment an integer value in a table. You will create a table called totals with columns name (text) and total (integer), insert sample data, and write a…
The task
Create a PostgreSQL database setup and demonstrate how to increment an integer value in a table. You will create a table called `totals` with columns `name` (text) and `total` (integer), insert sample data, and write a SQL statement that increments a specific row's total by 1.
Part of PrimeIntellect/Terminal-Lego-15k.