Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SLPRS CUSTOMER SLPRS_ ID SLPRS FNAME SLPRS LNAME SLPRS TELEPHONE SLPRS_HIRE_DATE CUST ID CUST TITLE CUST TELEPHONE CUST_ADDRESS CUST CITY CUST STATE CUST PC Lead

image text in transcribed

SLPRS CUSTOMER SLPRS_ ID SLPRS FNAME SLPRS LNAME SLPRS TELEPHONE SLPRS_HIRE_DATE CUST ID CUST TITLE CUST TELEPHONE CUST_ADDRESS CUST CITY CUST STATE CUST PC Lead Lead ID SLPRS ID Customer ID Date Expected date Amount Possibility Status 1. Write an SQL query to produce the average possibility of leads for each salesperson listing only those salesperson with average possibility more than 0.6 2. Write an SQL query to produce the average possibility of leads with status "I" for each salesperson listing only those salesperson with average possibility more than 0.6 3. Write an SQL query to produce an efficiency rate per salesperson. That is the (total amount* average possibility) /100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning VB 2008 Databases

Authors: Vidya Vrat Agarwal, James Huddleston

1st Edition

1590599470, 978-1590599471

More Books

Students also viewed these Databases questions

Question

Prepare a short profile of Lucy Clifford ?

Answered: 1 week ago

Question

Prepare a short profile of Rosa parks?

Answered: 1 week ago

Question

Prepare a short profile of victor marie hugo ?

Answered: 1 week ago

Question

12-5 How will MIS help my career?

Answered: 1 week ago