Count on same value from different columns in same table

[r937]

SELECT calldate , 'src' AS type , src AS code , COUNT(*) AS count FROM daTable GROUP BY calldate , src UNION ALL SELECT calldate , 'dst' AS type , dst AS code , COUNT(*) AS count FROM daTable GROUP BY calldate , dst ORDER BY calldate , type , code