Why did we switch from using * to selecting a specific column like age?

Hello Omar, really nice question.

Using * in SQL grabs every column in the table. It works, but it often gives you more data than you actually need. When you switch to something like:

SELECT age
FROM Customers;

you’re telling the database exactly what you want. That makes your query faster, easier to understand, and avoids pulling in extra or sensitive information by accident.

So the idea is simple:
Only ask for the columns you actually need.
It keeps the query clean and efficient.

If you have further questions, I'm here to help.