Let's write some T-SQL!

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!

Select the country column from the eurovision table.

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

SELECT country FROM eurovision;

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

SELECT country FROM eurovision;

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

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

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

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

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

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

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

SELECT country, event_year FROM eurovision;

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

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