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>;