264 B
264 B
sql
Who has the most follows?
SELECT subscriber_pubkey, COUNT(foaf_pubkey) AS foaf_count
FROM foaf
GROUP BY subscriber_pubkey
ORDER BY foaf_count DESC
LIMIT 10;
Count of all foafs
SELECT COUNT(*) as foaf_count FROM foaf;