List of product names and average value of offers, requests and transactions (0 if no offers --or
Fantastic news! We've Found the answer you've been seeking!
Question:
List of product names and average value of offers, requests and transactions (0 if no offers --or no requests or no transactions)
results should display 7 columns
name , Number of Offers, Average Offer Value , Number of Requests ,Average Request Value ,Number of transactions ,Average Transaction Value
product name is located in Tb_product
value of offer located in Tb_offers.price ( avg needed)
number of requests located in Tb_request.prod_id (distinct count needed)
request value in Tb_request.price (average needed)
number of transactions in Tb_Transactions.prod_id (distinct count needed)
transaction value in Tb_transactions.price (avg needed)
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: