Correct sir, but how to calculate that multiplier?

I'm interested in finding out what the average responses / applications, etc are based upon the mailer volume and mailer type fields. ...

Let's assume that's not an option, and the forecasting I'm looking for isn't anything overly sophisticated.

How would one approach this?

Based upon the attributes in 2 fields (volume of mail and...

It is. I apologize, for some reason, I figured this forum is able to tackle anything and any version of SQL

Thanks for the input guys..

I tried using the second solution with month(n.campaign_date)

..

WHERE

day(campaign_date) between 1 and 23

And I'm getting the following error.

ERROR: 42883: function day(timestamp without time zone) does not...

It's pretty simple, instead of

SELECT

DATE_TRUNC('month', n.campaign_date) <--- i want the date trunc to reflect ONLY the 1st - 23rd of every month. I then want to get...

DROP TABLE mytable;

CREATE TABLE mytable(

primary_attribute_value VARCHAR(33) NOT NULL PRIMARY KEY

, date VARCHAR(27) NOT NULL

, emails INTEGER(3) NOT NULL

, emails_delivered INTEGER(3) NOT NULL

, delivery_rate NUMERIC(6,4) NOT NULL

, opens INTEGER(2)...

I converted to CSV and I threw in a mock example since I'm still unclear how to write the syntax.

DROP TABLE mytable;

CREATE TABLE mytable(

FIELD1 VARCHAR(33) NOT NULL PRIMARY...

The action this whole query revolves around is the activity date (a.activity_date). a.activity_date is the date of an email send.

I'm trying to determine the dollar amount of activity triggered...

Hi , the reason I'm joining twice is because I need to account that opportunities can come from two different joins.

I just don't know how to write the syntax properly...the...