This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.Query 1 : display all assert by owner
SELECT o.OWNER_ID ,o.OWNER_FIRST_NAME, o.OWNER_LAST_NAME,
ast.ASSET_ID, ast.ASSET_NAME, ast.ASSET_TYPE, '$' || ast.ASSET_VALUE || 'k' as "ASSET_VALUE"
FROM ASSET ast,OWNER o
where o.OWNER_ID = ast.OWNER_ID
order by o.OWNER_ID