NowNow interview question

Questions on SQL, COUNTIF, SUMIF. Practically uses cases.