CLIs are often used by programmers and system administrators, in engineering and scientific environments, and by technically advanced personal computer users.
Global knowledge is like common sense, people know these things, but their may be someone else with the same idea. One person can come up with the idea but their is also another with same so don't give someone to much credit.
A select query
select column1, column2, columnN
from table
where condition
order to be pretty;