How can you return the number of records in the “campaigns” table?

How can you return the number of records in the “campaigns” table?

 

• SELECT COLUMNS(*) FROM campaigns
• SELECT COUNT(*) FROM campaigns
• SELECT NO(*) FROM campaigns
• SELECT LEN(*) FROM campaigns