ofelix03

SELECT name, email, s.ip_addresses
FROM users u
LEFT JOIN (
 SELECT user_id, string_agg(ip_address, ',') "ip_addresses"
 FROM site_visits
 WHERE country in ('China')
 and user_id = u.id
 GROUP BY user_id
) s
ON u.id = s.user_id

ofelix03

def pay_bill(bill_type, meter_number, amount):
  # we'll put the logic for how to process bill payment 
  # this could include validation rules, and service calls to complete pyment
  pass

ofelix03

# 1st call
median1 = find_median([40, 57, 12])
print(f"median1 = {median1}")

# 2nd call
median2 = find_median([3, 13, 7, 5, 21, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29])
print(f"median1 = {median2}")

# 3rd call
median3 = find_median([3, 13, 7, 5, 21, 23, 23, 40, 23, 14, 12, 56, 23, 29])

ofelix03

import math

def find_median(numbers=[]):
    """
      Implementation details

      Algorithm:
      1. Reorder numbers in ascending order
      2. Determine if the count of the numbers is even or odd
      3. If odd, divide by 2 and round up the result. Look up the median using your result as the lookup index. Skip step 4

ofelix03

import os
import hashlib

salt = os.urandom(32)
plaintext = 'hellow0rld'.encode()

digest = hashlib.pbkdf2_hmac('sha256', plaintext, salt, 10000)

hex_hash = digest.hex()
print(hex_hash)

ofelix03

ofelix03

import hashlib

plaintext = "hello".encode()

# instantiate sha3_256 object
d = hashlib.sha3_256(plaintext)

# generate binary bash of "hello" string
hash = d.digest()
print(hash)

ofelix03

import hashlib

plaintext = "hello".encode()
d = hashlib.sha256(plaintext)

# generate binary hash of "hello" string
hash = d.digest()
print(hash)

# generate human readable hash of "hello" string

ofelix03

ofelix03