COUNTIF and SUMIF are WHERE plus a total

COUNTIF is two steps squashed together: filter, then count. SQL keeps the steps visible: WHERE filters, COUNT counts.

Need several COUNTIFs side by side, like a little dashboard row? Put the condition inside the total with CASE:

SELECT
  SUM(CASE WHEN region = 'Europe' THEN quantity ELSE 0 END) AS europe,
  SUM(CASE WHEN region = 'Asia Pacific' THEN quantity ELSE 0 END) AS apac
FROM orders;