JDJulien Dephixinblog.juliendephix.fr路Dec 11, 2023 路 2 min readCalling all beginners: simple SQL challengeHi! Here's a little challenge for beginners. We have a users table and we need to know the number of users in 3 age ranges. if age < 18 then age range is minor. if age < 65 then age range is adult. if age >= 65 then age range is senior. Table struc...00
JDJulien Dephixinblog.juliendephix.fr路Dec 8, 2023 路 4 min readLet's have fun with MySQL JSON functions!Hello, coders! 馃捇 Intro I'd like to talk about SQL and how we can have fun with the many functions it has to offer. Today we'll have a look at how we can leverage JSON functions to help us build queries. What we want to retrieve from our database Let...00