I thought SQL clauses had to be in CAPITAL LETTERS?


#1

In the first SQL course I took with Codecademy they mentioned that Clauses perform specific tasks in SQL are written in CAPITAL LETTERS. Why then when I do the SQL: Analyzing Business Metrics, I see code like this:

select *
from order_items
order by id
limit 100;

I see lower case letters for the clause 'select * from'. Can anyone explain to me what is going on here?


#2

SQL will work no matter the casing that you use, but it is standard to use capital letters etc. for better readability.