mostlind

-- get all drugs, their side effects, and the frequencies of those side effects
select
	drugs.drug_id as drugId,
	drugs.name as drugName,
	side_effects.name as sideEffectName,
	drug_side_effects.frequency as sideEffectFrequency 
from drugs
	left join drug_side_effects on drug_side_effects.drug_id = drugs.drug_id
	left join side_effects on drug_side_effects.side_effect_id = side_effects.side_effect_id

mostlind

Excel functions

Chapter 2

Mean

=AVERAGE(array)

mostlind

function sum(arr) {
  // adds all the measurements in the sample
  return arr.reduce((a, b) => a + b);
}

function isWholeNumber(n) {
  // helper function
  return n % 1 === 0;
}

mostlind

(defn crackle-pop [n]
  (cond-> nil
    (zero? (mod n 3)) (str "Crackle")
    (zero? (mod n 5)) (str "Pop")
    :then ((fnil str n))))

(defn crackle-pop-range [start end]
  (map crackle-pop (range start (inc end))))

(doseq