SELECT co.ein,
       company_name as Company,
       CONCAT(fo.first_name,' ',fo.last_name) as Founder,
       CONCAT(ceo.first_name,' ',ceo.last_name) as CEO,
       CASE
         WHEN last_price IS NULL THEN '-'
         ELSE CONCAT('$',FORMAT(last_price,2))
       END as 'Current Stock Price'
FROM company co
LEFT JOIN stock s ON co.ein = s.ein
LEFT JOIN ceo ON co.ein = ceo.ein
LEFT JOIN founder fo ON co.ein = fo.ein
LEFT JOIN person p ON ceo.pid = p.pid
LEFT JOIN person ON fo.pid = p.pid