chukwujekwu-code

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

chukwujekwu-code

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;

chukwujekwu-code

SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name = table2.column_name;

chukwujekwu-code

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name
WHERE condition;

chukwujekwu-code

SELECT column_name(s)
FROM table1 T1, table1 T2
WHERE condition;

chukwujekwu-code

# typical subquery syntax
SELECT column_name
FROM table_name # the main query
WHERE column_name expression operator 
    ( SELECT COLUMN_NAME  from TABLE_NAME   WHERE ... ); # subquery

chukwujekwu-code

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
import plotly.graph_objects as go
from plotly.subplots import make_subplots
%matplotlib inline

chukwujekwu-code

# Load the dataset
df = pd.read_csv('EPL_20_21.csv')
df.head()

chukwujekwu-code

# View the first 20 rows
df.head(20)

chukwujekwu-code

# View the bottom 20 rows
df.tail(20)