求讨论一道关于ads conversion rate的sql题

[align="left"] Advertise Conversion Rate[/align][align="left"]TABLE1: Advertise {ads_id, timestamp,publisher_id, price}[/align][align="left"]TABLE2: VIEW {ads_id, timestamp, view, clicks}[/align][align="left"]QUESTION: conversionrate for publisher_id = 'P' and Date = 'date' (a specific publisher on aspecific date)[/align][align="left"]
[/align][align="left"]楼主想知道这里的conversion rate应该是用什么除以#clicks，第一个表格给出的price应该是投资额？[/align]