I have a database (“events_bank??) with news_headlines from x different sources.
Each news source will have 2 given keyword collections:
* List 1 will be a collection of single keywords
* List 2 will be a collection of combination keywords
Each news_headline will have, among many other attributes, a numerical performance value “I_C0??
For each news source, I want to calculate the average I_C0 for all news_headlines (SQL column ??hl_content??) of that source that match combinations of words in list 1 & 2.
Please see attached doc for more details. When bidding, you must answer the question at the end of the document.
Windows XP SP2
MS SQL Server 2005 Express