# Register the account name in AWS Billing

**Objective:** Assign account names based on the `lineitem/usageaccountid` column in the AWS environment.

**Use case:** Create a visualization to show cost by account name.

**SQL:**

```sql
CASE
    WHEN "lineitem/usageaccountid" = '1111111111111' THEN 'namexxxx'
    WHEN "lineitem/usageaccountid" = '222222222222' THEN 'nameyyy'
    WHEN "lineitem/usageaccountid" = '333333333333' THEN 'namezzz'
    WHEN "lineitem/usageaccountid" = '444444444444' THEN 'namewww'
    WHEN "lineitem/usageaccountid" = '555555555555' THEN 'namettt'
    ELSE "lineitem/usageaccountid"
END
```

***