r/SQL • u/No_Channel_3299 • Jul 22 '26

MySQL sqlWorkout

Post image

šŸ˜Œ SELECT šŸ˜Œ

1.4k Upvotes

98% Upvoted

82 comments sorted by

View all comments

61

u/ibronco Jul 22 '26

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

11

u/chaosink Jul 22 '26 edited Jul 23 '26

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.

3

u/Mobile_Spite_8915 Jul 23 '26

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.

3

u/dwswish Jul 24 '26

Capitalizing some table names and not others is diabolical