Job acceptance rates by location in SQL
Suppose you're trying to determine which locations drive a higher offer acceptance rate at your company.
You're given the below tables, detailing candidate offer statuses ('Accepted', 'Declined', 'Rejected') as well as a table containing the location of the role each candidate is interviewing for. Using these tables, write a SQL query to return the percent of offers given that are accepted by location.
Note: If a candidate's status is in 'Accepted' or 'Declined' that means that they have received an offer, while if the status is in 'Rejected' that candidate did not receive an offer.
Click here to view/query these tables in an interactive SQL fiddle.
Subscribe to premium account to see the solution.Get premium now