select * from views
where referrer like ‘%phoenix%’
order by time desc

(Interpreting “*” as “all”, ignoring pronunciation of “%”, and pronouncing “desc” as one syllable.)