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;
Day 60 Of #100DaysOfCode and #Python
— Durga Pokharel (@mathdurga) February 26, 2021
* Algorithmic Toolbox
* Intermediate SQL(CASE Statement ) #WomenWhoCode #100DaysOfCode #CodeNewbie #DEVCommunity pic.twitter.com/h3Icwdkt7m
Top comments (0)