>yes my SQL queries are all lowercase. So what?
Yes my SQL queries are all lowercase. So what?
Jordan Moore
Adam Jones
not my problem
Charles Gutierrez
Lowercase ASCII characters are higher numbers than uppercase. Enjoy wasting space.
Nathaniel Green
Lol.
Luke Hall
I pronounce SQL as "squirrel"
Hunter Williams
Yeah makes sense. It isnt 80s anymore. We have syntax highlighting.
Parker Kelly
same, lower case sql is more aesthetic and idgaf
Sebastian Scott
BROOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO, nice bait
Adrian Ramirez
>I dont write SQL, I use an ORM instead.
Dominic Anderson
I prefer uppercase. Lower case looks zoomie. Like some retarded twitter post.
Isaac Bailey
These gigachad opinions never fail to make me laugh
Benjamin Flores
really? I kinda got tired of em
Levi Bennett
I don't make queries, I just type down what I remember is in there. If I can't remember it, it's not that important.
Jose Hall
Lowercase and I split functional sections into lines because I fucking hate massive SQL statements that all run together.
>select fuck, this, shit, lulz.hahaha
>from clownworld
>inner join lulz on clownworld.fuck = lulz.everything
>where lulz.for = 'THE'
Bentley Adams
>I don't use indexes or FTS.
Wyatt Moore
This
Gabriel Price
Cringe if you dont also know SQL based otherwise
Oliver Edwards
Yes, i don't use SQLs, i prefer to write the queries on my on using the language that i'm using.
Nathan Phillips
love me some well commented, well indented queries
-- Calcul de la moyenne des données fiscales à la maille communale
SELECT
s. CODE_INSEE ,
sum ( r_men_basr ) AS men_basr , -- Nombre total de ménages dont le revenu fiscal par unité de
consommation est inférieur au seuil de bas revenu
sum ( r_ind_srf ) AS sum_srf , -- Somme totale des revenus fiscaux
avg ( r_men_basr ) AS men_basr , -- Nombre moyen de ménages dont le revenu fiscal par unité de
consommation est inférieur au seuil de bas revenu
avg ( r_men_surf ) AS avg_surf , -- Surface moyenne des ménages
avg ( r_men_prop ) AS avg_prop , -- Nombre moyen de ménages propriétaires
avg ( r_ind_srf ) AS avg_srf , -- Moyenne des revenus fiscaux
max ( r_men_basr ) - min ( r_men_basr ) AS amp_basr , -- Amplitude du nombre de ménages dont le revenu
fiscal est inférieur au seuil de bas revenu (écart entre le maximum et le minimum )
max ( r_men_surf ) - min ( r_men_surf ) AS amp_surf , -- Amplitude de la surface des ménages
max ( r_men_prop ) - min ( r_men_prop ) AS amp_prop , -- Amplitude du nombre de ménages propriétaires
par carreau
max ( r_ind_srf ) - min ( r_ind_srf ) AS amp_srf , -- Amplitude des revenus fiscaux par unité de
consommation
sqrt (( sum ( r_ind_srf * r_ind_srf ) - sum ( r_ind_srf ) * sum ( r_ind_srf ) / count ( r_ind_srf ) ) / ( count (
r_ind_srf ) -1) ) AS stdev , -- Ecart type des revenus fiscaux par unité de consommation
s. geometry AS geometry
FROM sdrive_caz_sql_union_refac s
JOIN car_caz_join c
ON st_intersects ( s . geometry , c . geometry )
GROUP BY CODE_INSEE
Carson Gray
thanks for the laugh, I'm sad no one fell for it
Dylan Gray
kek