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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Sql SELECT Pname AS productname IFNULLOnumoffers 0 AS NumberofOffers IFNU...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Income Tax Fundamentals 2013
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
31st Edition
1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516
