Customer card: projection with aliases
Customer card: projection with aliases
At "Kotomarket" the marketing team prepares a customer export for a mailing and wants the column headers to be readable.
The customers table holds the shop's customer data.
For every customer, output three columns, renaming them with AS:
- full_name as klient;
- city as gorod;
- signup_date as data_registracii.
No filtering, sorting or other transformations are required — just a projection of the needed columns with aliases.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| klient | gorod | data_registracii |
|---|---|---|
| Анна Котова | Москва | 2024-01-12 |
| Игорь Лапкин | Санкт-Петербург | 2024-02-03 |
| Мария Усова | Казань | 2024-02-21 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid