Question: Samantha interviews many candidates from different colleges using coding challenges and contests. Write a query to print the contest id , hacker jd , limhe
Samantha interviews many candidates from different colleges using coding
challenges and contests. Write a query to print the contest id hacker jd limhe and
the sums of total submissions, totalacceptedsubmissions, total views, and
total unique views for each contest sorted by contest id Exclude the contest from
the result if all four sums are
Note: Aspecific contest can be used to screen candidates at more than one college,
but each college only holds screening contest
Input Format
The following tables hold interview data:
Contests: The contestid is the id of the contest, hacker id is the id of the hacker
who created the contest, and name is the name of the hacker.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
