Let's write some T-SQL!

Let's write some T-SQL!

University

9 Qs

quiz-placeholder

Similar activities

ATLAS BHSF 2021 QUIZ - DAY 1

ATLAS BHSF 2021 QUIZ - DAY 1

University

10 Qs

Heat Emergencies Presentation

Heat Emergencies Presentation

University

12 Qs

Anatomy of lower limb

Anatomy of lower limb

University

10 Qs

NURS 2150: Birth Related Stressors

NURS 2150: Birth Related Stressors

University

10 Qs

Advanced Concepts Quiz Four Review

Advanced Concepts Quiz Four Review

University

10 Qs

CANARA CHANAKYA QUIZ ON FOUNDERS DAY 2019

CANARA CHANAKYA QUIZ ON FOUNDERS DAY 2019

10th Grade - Professional Development

11 Qs

IELTS Speaking Quiz

IELTS Speaking Quiz

9th Grade - University

12 Qs

Jungkook Quiz

Jungkook Quiz

KG - Professional Development

10 Qs

Let's write some T-SQL!

Let's write some T-SQL!

Assessment

Quiz

Specialty

University

Practice Problem

Hard

Created by

Thuan Tran

Used 5+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

9 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Media Image

It's time to begin writing your own queries! In this first coding exercise, you will use SELECT statements to retrieve columns from a database table. You'll be working with the eurovision table, which contains data relating to individual country performance at the Eurovision Song Contest from 1998 to 2012.

Yes

Ok, let go!

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Select the country column from the eurovision table.

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Amend your query to return the points column instead of the country column.

SELECT country FROM eurovision;

4.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Amend your query to return the points column instead of the country column.

SELECT country FROM eurovision;

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Use TOP to change the existing query so that only the first 50 rows are returned.

SELECT ........ (........) points FROM eurovision;

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Return a list of unique countries using DISTINCT. Give the results an alias of unique_country.

SELECT ........ country ........ unique_country FROM eurovision;

7.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • SELECT the country and event_year columns from the eurovision table.

SELECT ........ , ........ FROM ........;

8.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Use a shortcut to amend the current query, returning ALL columns in the table.

SELECT country, event_year FROM eurovision;

9.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • This time, return only half the rows using 'TOP', using the same shortcut as before to return all columns.

SELECT ........ (50) PERCENT * FROM eurovision;