sql_REGEXP_REPLACE.sql

/*
You are given a table named repositories, format as below:

** repositories table schema **

project
commits
contributors
address
The table shows project names of major cryptocurrencies, their numbers of commits and contributors and also a random
donation address ( not linked in any way :) ).

Your job is to remove all numbers in the address column and replace with '!', then return a table in the following format:

** output table schema **

project
commits
contributors
address
Case should be maintained.

*/

SELECT project,
       commits,
       contributors,
       regexp_replace(string := address, pattern := '[[:digit:]]', replacement := '!', flags := 'g') AS address
FROM repositories;