fname || ' ' || lname "fname" || ' ' || "lname" CONCAT(`customer`.`fname`, ' ', `customer`.`lname`) FULLNAME fname || ' ' || lname "fname" || ' ' || "lname" CONCAT(`customer`.`fname`, ' ', `customer`.`lname`) FULLNAME [Measures].[Store Sales] - [Measures].[Store Cost] CASE WHEN UNITS_SHIPPED IS NOT NULL THEN PRODUCT_ID END