Meta Interview Question

They described a transactional table, ask for SQL on whiteboard to generate a fact table.