如何将我自己的数字插入分区查询？

Question

I have a query that works well. Only problem is it is dividing by a number of rows pulled from my database from the select statement. How do I change

(SELECT COUNT(*) FROM saved_players))

to lets say 1000? 1000 being the total number of members.

$query= "SELECT *, COUNT(*) AS Total , (COUNT(*) / (SELECT COUNT(*) FROM saved_players)) * 100 AS totalnumber
FROM saved_players
GROUP BY fname";

So I am looking for something like below but it doesn't work.

$query= "SELECT *, COUNT(*) AS Total , (COUNT(*) / 1000 * 100 AS totalnumber
FROM saved_players
GROUP BY fname";

Answer 1

$query= "SELECT *, COUNT(*) AS Total , (COUNT(*) / 1000 * 100) AS totalnumber
FROM saved_players
GROUP BY fname";

Looks like missing bracket).

Hope this helps