Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

SELECT FROM statement

Theory

After SELECT

Report a typo

The table "winners" has the following columns:

  • integer year

  • boolean is_winner

  • varchar(50) discipline

  • integer place (0, 1, 2)

  • varchar(50) full_name

  • varchar(30) nation

Consider the following query:

SELECT ? FROM winners;

What should be placed instead of a ? in order to generate the result shown below?

year

discipline

place

full_name

1948

Skating, men, single

1

Dick Button

1948

Skating, men, single

2

Hans Gerschwiler

1948

Skating, men, single

3

Edi Rada

...

...

...

...

1948

Swimming, women, 100m backstroke

3

Georges Vallerey

Select one option from the list
___

Create a free account to access the full topic