SELECT
    t1.s_id as t1_s_id,
    t2.s_id as t2_s_id,
    t3.s_name,
    t1.s_score as s_score_01,
    t2.s_score as s_score_02
FROM
    (select s_id, c_id, s_score from Score WHERE c_id = '01') as t1
INNER JOIN
    (select s_id, c_id, s_score from Score WHERE c_id = '02') as t2
ON t1.s_id = t2.s_id
INNER JOIN
    Student as t3 
ON t1.s_id = t3.s_id
where t1.s_score > t2.s_score

SELECT DISTINCT column1, column2, ...
FROM table_name;

SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

SELECT MIN(column_name), MAX(column_name), COUNT, AVG, SUM
FROM table_name
WHERE condition;

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

SELECT *
FROM Orders
LEFT JOIN Customers

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

SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country
HAVING COUNT(CustomerID) > 5;

SELECT City FROM Customers
UNION
SELECT City FROM Suppliers
ORDER BY City;