Bringing it all Together

Data Manipulation in SQL

Mona Khalil

Data Scientist, Greenhouse Software

What you've learned so far

• CASE statements
• Simple subqueries
• Nested and correlated subqueries
• Common table expressions
• Window functions

Let's do a case study!

Who defeated Manchester United in the 2013/2014 season?

Steps to construct the query

• Get team names with CTEs
• Get match outcome with CASE statements
• Determine how badly they lost with a window function

Getting the database for yourself

Full European Soccer Database

Let's practice!

Data Manipulation in SQL