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, total_accepted_submissions, total views, and
total unique views for each contest sorted by contest id. Exclude the contest from
the result if all four sums are 0.
Note: Aspecific contest can be used to screen candidates at more than one college,
but each college only holds 1 screening contest
Input Format
The following tables hold interview data:
Contests: The contest_id 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.
 Samantha interviews many candidates from different colleges using coding challenges and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!