Project 8: Event Column Aliasing
SQL Architect
Builds on these lessons
Query Task
Objective
SELECT can rename a column in its output with AS — the underlying column name in the table never changes, only how it's labeled in the results you get back.
You're given an events table with columns id, title, date, and guests.
Task: write a query that returns title (labeled as event_name) and date, for every row.
query.sql
SELECT title AS event_name, date FROM events;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results