aditya

CREATE TABLE accounts(
	id serial PRIMARY KEY,
	name VARCHAR(256) NOT NULL
);

CREATE TABLE entries(
	id serial PRIMARY KEY,
	description VARCHAR(1024) NOT NULL,
	amount NUMERIC(20, 2) NOT NULL CHECK (amount > 0.0),
	-- Every entry is a credit to one account...

aditya

begin;
 
select count(*)
from actions
where item_type='Story'
    and item_published_at is not null;
 
select count(distinct(item_id))
from actions
where item_type='Story'