Querydrill

Level 1: Basics Exercise 1 of 60 Free

Pick two columns

An SQL exercise from Querydrill. Solve it with a SQL editor in your browser, checked on the rows it returns and again on changed data, and it is checked the moment you submit.

The task

Return the name and country of every customer.

What this exercise teaches

SELECT chooses columns, FROM chooses the table. Avoid SELECT * in real work; ask only for what you need.

A hint if you get stuck

List the columns after SELECT, separated by commas, then name the table after FROM.

Try it now, no account needed

This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.

Open this exercise

More exercises in Basics