@a_musingcat aww, it's the complex ones that make my brain hurt too! if you're not doing 3 levels of aggregation & nested subqueries are you even really writing sql?
More notes on nearby ideas
Reply · Jul 24, 2021@sabrinaesaquino Oh, and spend some time on aggregations, date functions & comparisons, and basic string functionsReply · Jul 24, 2021@sabrinaesaquino Good luck! Focus on grokking foreign keys and joins in queries, and practice writing simple queries to answer questions. Also do a…Reply · May 7, 2023(id, other_id, json_blob) is all you needReply · Aug 24, 2023@a_musingcat 🤣 what's your feeling about tools that enable chat questions to query SQL DBs & turn the answer back into a human-friendly answer?