SELECT customer_id AS "Cust ID",
cust_first_name || ' ' || cust_last_name AS "Name",
cust_street_address1 AS "Street 1",
cust_street_address2 AS "Street 2",
cust_city AS "City",
cust_state AS "State",
cust_postal_code AS "Zip",
phone_number1 AS "Phone",
credit_limit AS "Credit Limit"
FROM demo_customers
ORDER BY 1