SELECT COUNT(DISTINCT relation)
FROM Nell;
-- 225

SELECT COUNT(DISTINCT entity)
FROM Nell;
-- 402939

SELECT COUNT(DISTINCT value)
FROM Nell;
-- 53245

SELECT COUNT(DISTINCT A.value)
FROM Nell A, Nell B
WHERE A.value = B.entity;
-- 15040

SELECT (0.0 + X.a)/Y.b
FROM
	(SELECT COUNT(*) as a
	FROM Nell
	WHERE p < 1.0) as X,
	(SELECT COUNT(*) as b
	FROM Nell) as Y;
-- 0.86078822940313779665

SELECT relation, count(relation) AS frequency
FROM Nell
GROUP BY relation
ORDER BY frequency DESC
LIMIT 10
OFFSET 0;
--           relation           | frequency 
--		------------------------------+-----------
--		 generalizations              |    398254
--		 concept:latitudelongitude    |     42583
--		 concept:animalistypeofanimal |      5874
--		 concept:animaltypehasanimal  |      5874
--		 concept:proxyfor             |      2824
--		 concept:proxyof              |      2824
--		 concept:animalpredators      |      1910
--		 concept:animalpreyson        |      1910
--		 concept:subpartof            |      1615
--		 concept:superpartof          |      1615
--		(10 rows)


SELECT value, count(value) AS frequency
FROM Nell
GROUP BY value
ORDER BY frequency DESC
LIMIT 10
OFFSET 0;
--       value        | frequency 
--	--------------------+-----------
--	 concept:city       |     10893
--	 concept:celebrity  |      9644
--	 concept:university |      9610
--	 concept:animal     |      9523
--	 concept:vertebrate |      9326
--	 concept:bird       |      8953
--	 concept:sportsteam |      7230
--	 concept:disease    |      7000
--	 concept:writer     |      6942
--	 concept:chemical   |      6423
--	(10 rows)
