Oracle SQL Interview Question | Answered with Explanation in Kannada | Who Made Quota?
#kaliyona #teamkaliyona #sqlinterview
www.kaliyona.com
As a data analyst on the Oracle Sales Operations team, you are given a list of salespeople’s deals, and the annual quota they need to hit.
Write a query that outputs each employee id and whether they hit the quota or not ('yes' or 'no'). Order the results by employee id in ascending order.
Definitions:
deal_size: Deals acquired by a salesperson in the year. Each salesperson may have more than 1 deal.
quota: Total annual quota for each salesperson
Question Credits and Courtesy: https://datalemur.com/questions/match...
Follow us on social media:
/ teamkaliyona
/ teamkaliyona
/ teamkaliyona
#sql #sqlinterview #sqlinterviewquestionsandanswers #kaliyona
SQL Interview Questions in Kannada