I have a table defined as follows:
CREATE TABLE safety (
sid SERIAL,
side INTEGER,
InjDate DATE,
InjType INTEGER,
Outcome INTEGER,
PRIMARY KEY (sid)
);
What I'm trying to generate is a list of all outcomes and how many of each
that occured for a particular range of dates.
This works but doesn't do dates:
SELECT outcome,count(outcome) from safety
GROUP BY outcome;
How do I incorporte dates into this query.
Adding a WHERE clause to the query doesn't work for example:
SELECT outcome,count(outcome) from safety
GROUP BY outcome
WHERE InjDate='2000-11'14';
Any tips or advice would be apreciated.
Shawn