Answered step by step
Verified Expert Solution
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
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
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