O'Reilly logo
  • Matthew Perkovic thinks this is interesting:

SELECT COUNT(*) AS num_prods FROM products WHERE vend_id = 1003;

From

Cover of MySQL® Crash Course

Note

How to count all columns?