DB Basics - May 2018

--Build-in Functions
--11. Mix of Peak and River Names
select p.PeakName,
        r.RiverName,
        concat(lower(p.PeakName), lower(r.RiverName)) as Mix
from Peaks p
    inner join Rivers r on
        (substring(r.RiverName, 1,1) = substring(p.PeakName, len(p.PeakName), 1))
order by Mix