POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is an alias in PostgreSQL?

How do you create an alias for a column in PostgreSQL?

Why might you use an alias for a column in PostgreSQL?

Can you use aliases in the WHERE clause in PostgreSQL? Explain why or why not.

Explain how you can use column aliases in combination with aggregate functions in PostgreSQL.

Is it possible to use an alias for an expression in the SELECT statement? Give an example.

How can you use table aliases and column aliases together in a PostgreSQL query?

Describe a scenario where using column aliases in a join query would be beneficial.

Can column aliases be used in the ORDER BY clause in PostgreSQL? Provide an example.

How do column aliases affect the portability of PostgreSQL queries to other RDBMS like Oracle?