Q9: Write an SQL query using CASE to calculate the grade for each student:
If the avg of math and science scores is greater than or equal to 90, assign A grade.
If the avg is between 80 & 89, assign B grade
If the avg is between 70 & 79, assign C grade
Otherwise, assign 'D'.
Protip: 😎 Do you know that using the LEAD and LAG functions effectively and considering both the PARTITION BY and ORDER BY clauses, you can perform robust time-based and comparative analysis on your data in Oracle SQL. 🚀
A master class in creating Synthetic datasets with LLMs! 🐐
ToolLLM paper has been popular for creating the strongest API following models.
I think there’s an incredibly underrated side to it, here’s my summary:
- The paper aims to improve API following capabilities of open…
3K Followers 3K FollowingMicrosoft Data Platform MVP. Principal consultant at Purple Frog Systems, a U.K. Data Analytics Consultancy. Pilot and F1 nut. Views are my own. (He/Him)
11K Followers 2K FollowingSQL Server DBA, Owner/Founder at Stedman Solutions, LLC., Entrepreneur, Instructor, and Geek. Get your free SQL Joins poster here: https://t.co/ZEnsX3l1kp
636 Followers 2K FollowingRocky Balboa’s Soldier -SQL Server / Azure SQL DB / Azure SQL MI Speaker @sqlargentina blog https://t.co/fLDgxz6TVB MVP Data Platform
852 Followers 292 FollowingCloud Solution Architect, Data Platform MVP, MCT. Passionate about data and architecture 🧩 Math nerd in a previous life 🤓 Love riding bikes 🚵🏼♀️
18K Followers 5K FollowingRedgate creates ingeniously simple software to help data professionals get the most value out of any database, anywhere, through end-to-end Database DevOps.
636 Followers 2K FollowingRocky Balboa’s Soldier -SQL Server / Azure SQL DB / Azure SQL MI Speaker @sqlargentina blog https://t.co/fLDgxz6TVB MVP Data Platform
77 Followers 204 FollowingEvery day on the front line to do my best with sun, mountain, running, wine and beers .. and yes, also to solve SQL Server problems, query tuning and much more!
10K Followers 6K FollowingThe next generation of decision intelligence.
Incorporated in Amsterdam with regional HQs in London, NYC, and Tel Aviv, and a globally distributed team.
2K Followers 2K FollowingGlobal Data & AI CSA @Microsoft. A Tenacious DBA. Family,Mountains,Celtic games,video games. Opinions my own. He/Him https://t.co/oBQlfyRj1P
2K Followers 828 FollowingGroup Manager at @avanadeuki. Data Platform #MVP, MCSE. Blogger, speaker, data geek. #azure #sqlfamily @SQLDay @DataRelay_UK. He/him.
My own opinions.
11K Followers 2K FollowingSQL Server DBA, Owner/Founder at Stedman Solutions, LLC., Entrepreneur, Instructor, and Geek. Get your free SQL Joins poster here: https://t.co/ZEnsX3l1kp
4K Followers 907 FollowingBI pro and tattooed #sqlserver geek. Data warehousing. Former Data Platform MVP. Punk rock fan. Married & father of 2. He/him @[email protected].
4K Followers 4K FollowingDatabase Developer, Freelancer, bearer of the Dark Spade (aka Oracle ACE ♠), #DOAGeV member and delegate. I ❤️ #SQLDev #orclapex #plsql #yessql 🇬🇧 sie|she
1K Followers 2K FollowingI'm not pedantic, I'm neurospicy
Occasionally adults.
Sorry, I was ADHDing during that meeting.
Mostly over on the other platform.
522 Followers 718 FollowingCurrently work as a DBA AWS Aurora PostgreSQL, SQL Server and DB2, I've been a DBA for 14 years. Developer for over 30 years PaaS Windows Linux
973 Followers 828 FollowingLatina / Mother/ Dog lover /Community Builder/ Change agent/ Mentor/ 1% of Latinas in data #womenintech #diversityequityandinclusion
2K Followers 1K FollowingDad, @UF Gator Alumnus, @Braves fan,Lover of @SQLServer, #SQLScuba, Melomaniac, Star Wars fan boy, Power BI Aficionado and Former Data MVP. (He/Him)
1K Followers 404 FollowingData focused developer. YouTuber. Wearer of many hats 🤠. Trying to brew the perfect cup of coffee. @[email protected] @bertwagner.bsky.social
3K Followers 1K FollowingData Platform MVP. Formula 1 DBA.
Founder at @quantumdatis
Retired account, please find me with same handle where the sky is blue
No recent Favorites. New Favorites will appear here.