Let’s continue our discussion about formatting queries.
Lower case vs upper case
Throughout the whole course you saw the queries formatted using the upper case:
SELECT id AS user_id, SPLIT_PART(email, '@', 2) AS email_domain FROM users WHERE country = 'us' AND status = 'customer'
Of course, it’s not the only way of doing this. Here’s the same query using the lower case:
select id as user_id, split_part(email, '@', 2) as email_domain from users where country = 'us' and status = 'customer'
Crazy, right? It looks, feels and reads like a...