I thought SQL clauses had to be in CAPITAL LETTERS?

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?

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

2 Likes