CYW

1.sql

/*
Enter your query here.
Please append a semicolon ";" at the end of the query
*/
SELECT c.name, MAX(p.id)
FROM customer as c, payment as p
WHERE p.status LIKE "CO" and p.customer_id = c.id
GROUP BY c.name

2.py

def applyRoundingRules(original_amount):
    if original_amount < 25:
        return 50

    # Write your code here
    int_div = original_amount // 50
    rest_div = original_amount % 50


    return int_div * 50 if rest_div < 25 else (int_div + 1) * 50

3.py

def generateSkylineString(buildingHeightsAsString):
    result = []
    for i in range(9):
        line = ['#' if (9 - i) <= int(j) else ' ' for j in buildingHeightsAsString]
        result.append(''.join(line))

    return '\n'.join(result)

4.py

def decompress(linesAsStringArray):
    result = []
    for line in linesAsStringArray:
        list_char = line[::2]
        list_num = line[1::2]
        result.append(''.join([ list_char[i] * int(list_num[i]) for (i, _) in enumerate(list_char)]))
    
    return '\n'.join(result)

5.sql

SELECT euin.uin, e.name FROM employee as e, employee_uin as euin
WHERE e.age < 25 AND e.id = euin.id
ORDER BY e.name, e.id ASC