Formatting text for colleagues
A website to monitor filming activity in New York City is being constructed based on film permit applications stored in film_permit. This website will include information such as an event_id, parking restrictions required for the filming (parking_held), and the purpose of the filming.
Your task is to deliver data to the web development team that will not require the team to perform further cleaning. event_id values will need to be padded with 0s in order to have a uniform length, capitalization for parking will need to be modified to only capitalize the initial letter of a word, and extra spaces from parking descriptions will need to be removed. The REGEXP_REPLACE() function (introduced in one of the previous exercises) will be used to clean the extra spaces.
この演習はコースの一部です
Cleaning Data in PostgreSQL Databases
実践的なインタラクティブ演習
このサンプルコードを完成させて、この演習に挑戦してみましょう。
SELECT
-- Add 0s to ensure each event_id is 10 digits in length
___(___, ___, ___) as event_id,
parking_held
FROM
film_permit;