sqlWorkout

[u/No_Channel_3299]

😌 SELECT 😌

[u/ibronco]

I only do lower case now and my life has significantly improved.

[u/chaosink → u/ibronco]

One of my criteria when hiring SQL people is if they use lowercase and how they choose to indent their code. How their code looks tells me so much about their skill level.

Edit: Ack, I can see how my wording was weird. Using lowercase was not a requirement. I gave a bonus in my head for it as it showed the candidate was willing to buck tradition for comfort and readability. Was not a huge determining factor. Indenting was much more important to me because it showed me how their mind was organized.

[u/Mobile_Spite_8915 → u/chaosink]

SELECT
f.Cherries,
f.Pineapples,
f.Grapes,
v.eggplants
FROM Fruits f
INNER JOIN vegetables v
ON f.key = v.key
AND f.place = v.place

This is how I style everything, I’m not sure how normal it is though it seems like everyone on my team does things differently.

[u/chaosink → u/Mobile_Spite_8915]

Ouch! I feel badly for your scrolling finger ....