SELECT
peak_name,
river_name,
LCASE(CONCAT(
SUBSTRING(peak_name,1,CHAR_LENGTH(peak_name)-1),
river_name)) AS mix
FROM peaks,rivers
WHERE
SUBSTRING(river_name,1,1) = SUBSTRING(peak_name,-1)
ORDER by mix;