HELP with SQL Question

HELP with SQL Question

HELP with SQL Question

I have a homework assignment and I need to join two tables, EMAILS and KEYWORDS, both have 70k+ rows. I’ve included a sample of the tables below. The prompt is: “Generate a query that returns a dataset showing how often each employee discussed demos (KEYWORD=demo, Demo, etc) in their emails, grouped by quarter. Assume the results of this query will be used to populate a graph in the application.” I understand that I need to COUNT(), join the tables on EMAIL_KEY, and group by EMPLOYEE_ID but I don’t understand how I could also group by QUARTER which is what the prompts says to do. I guess QUARTER can be taken from the DATETIME column but still not sure how I would structure this. Any help is appreciated.

EMAILS

KEYWORDS

submitted by /u/Tyraniczar
[link] [comments]


Go to Source of this post
Author Of this post: /u/Tyraniczar
Title Of post: HELP with SQL Question
Author Link: {authorlink}