DEV Community

Durga Pokharel
Durga Pokharel

Posted on

Day 60 Of 100DaysOfCode: Intermediate SQL

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

Discussion (0)