SELECT COUNT(*) FROM tablename; #### SELECT COUNT(DISTINCT customer_id) FROM purchases;