Days to first sale

Question

You’re working as an analyst for a sales organization and you’re asked to figure out how long it takes for a sales representative to make their first sale. You’re also given the following tables:
Table 1: sales_rep_info

column description
sales_rep_id unique sales rep identifier
date_hired hire date of employee, format 'YYYY-MM-DD'
product_focus_area types of products the rep sells
tenure total yrs of sales experience
level employee level at the company

Table 2: all_sales

column description
date close date of sale, format 'YYYY-MM-DD'
purchase_order_number unique identifier for the sale
buyer_id the unique identifier for buyer
sales_rep_id unique sales rep identifier of the
order_price_usd total sales price in USD
date_sale_initiated date the purchase order was initiated, format 'YYYY-MM-DD'

Can you write a SQL query that shows how long it takes for a sales representative to make their first sale?

Solution

Access restricted

Subscribe to premium account to see the solution.

Get premium now