Pick the code that shows the amount of years where no Medicine awards were given

Worried Warbler answered on September 29, 2021 Popularity 1/10 Helpfulness 1/10

Comment

SELECT COUNT(DISTINCT yr) FROM nobel
 WHERE yr NOT IN (SELECT DISTINCT yr FROM nobel WHERE subject = 'Medicine')

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: sqlzoo.net

Tags: pick whatever where

Link to this answer
Share Copy Link

Contributed on Sep 29 2021

Worried Warbler

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.