Write SQL query to solve given problem: How many "all" character names have the "all" abbreviation?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT COUNT(id) FROM characters WHERE Abbrev = 'All'