SELECT COUNT(ID) AS IncidentsByDecade, SUM('dead victim count') AS DeadByDecade FROM TABLE 'MassMurder' GROUP BY 'year';What's the syntax error? And is there a way to GROUP BY year/10? Or do I need to create a separate field of decade calculated from the year field?
Conservative. Idaho. Software engineer. Historian. Trying to prevent Idiocracy from becoming a documentary.
Email complaints/requests about copyright infringement to clayton @ claytoncramer.com. Reminder: the last copyright troll that bothered me went bankrupt.
Pages
▼
SELECT COUNT(ID) AS IncidentsByDecade, SUM('dead victim count') AS DeadByDecade FROM TABLE 'MassMurder' GROUP BY 'year';
ReplyDeleteshould be
SELECT COUNT(ID) AS IncidentsByDecade, SUM('dead victim count') AS DeadByDecade FROM 'MassMurder' GROUP BY 'year';