Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please provide proof that your answer works. Given tables students, difficulty, contests, and submissions with the following schemas. students Column Type student_id INTEGER name TEXT

image text in transcribed

please provide proof that your answer works.

Given tables students, difficulty, contests, and submissions with the following schemas. students Column Type student_id INTEGER name TEXT divisions Column Type division_id INTEGER score INTEGER contests Column Type contest_id INTEGER author_id INTEGER division id INTEGER submissions Column Type submission_id INTEGER student_id INTEGER contest_id INTEGER score INTEGER The submissions table contains a submission (submission id) made by a student student id) to a contest (contest_id) and the score of the submission (score). A student can make multiple submissions to the same contest and receive multiple scores. The contests table contains the author (authorld) of their contest submission (contest id) that belongs to a certain division (division_id). The divisions table contains the max score (scorel of each contest that belongs to a certain division division_id). wie SOL query to retrieve the student and name of the students who received max scores in more than one contest. Order the results try first the total number contests in which the student earned a full score, and then the studenti in ascending order)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Infrastructure For Medical Research In Databases

Authors: Thomas Heinis ,Anastasia Ailamaki

1st Edition

1680833480, 978-1680833485

More Books

Students also viewed these Databases questions

Question

Is DirectAccess implemented outside of the Remote Access server?

Answered: 1 week ago