Select all fields from one specific table.

select * from <table_name>;

Select some fields like first_name, last_name from one specific table.

select first_name, last_name from <table_name>;

Use expressions to associate multiple fields, set a new column name.

select first_name || ' ' || last_name as full_name from <table_name>;