SQL_7

SELECT ID, FIRST_NAME || ' ' || LAST_NAME AS NAME, EXPERTISE || ', ' || AUTH_EXPENSE_AMT || ', ' || MANAGER_ID AS 'Partner_Information' FROM d_partners