DEV Community

Durga Pokharel
Durga Pokharel

Posted on

Day 60 Of 100DaysOfCode: Intermediate SQL

#womenintech #codenewbie #100daysofcode #beginners

Today is my 60th day of #100DaysOfcode and #python learning. Today I learned intermediate SQL( CASE statement) from Datacamp. Also had taken video lecture of Algorithmic toolbox from Coursera

SQL CASE Statement 

SELECT season, date, home_goal, away_goal FROM matches_italy WHERE CASE WHEN hometeam_id = 9857 AND home_goal > away_goal THEN 'Bologna Win' WHEN awayteam_id = 9857 AND away_goal > home_goal THEN 'Bologna Win' END IS NOT NULL;
Enter fullscreen mode Exit fullscreen mode

Day 60 Of #100DaysOfCode and #Python
* Algorithmic Toolbox
* Intermediate SQL(CASE Statement ) #WomenWhoCode #100DaysOfCode #CodeNewbie #DEVCommunity pic.twitter.com/h3Icwdkt7m

— Durga Pokharel (@mathdurga) February 26, 2021

Top comments (0)