Scholar Repository
Home>Manual>SQL Exercises

SQL Exercises

From http://www.w3schools.com (Copyright Refsnes Data)

SQL Try It

previous next


Test your SQL Skills

On this page you can test your SQL skills.

We will use the Customers table in the Northwind database:

CompanyName ContactName Address City
Alfreds Futterkiste  Maria Anders  Obere Str. 57  Berlin 
Berglunds snabbk�p  Christina Berglund  Berguvsv�gen 8  Lule� 
Centro comercial Moctezuma  Francisco Chang  Sierras de Granada 9993  M�xico D.F. 
Ernst Handel  Roland Mendel  Kirchgasse 6  Graz 
FISSA Fabrica Inter. Salchichas S.A.  Diego Roel  C/ Moralzarzal, 86  Madrid 
Galer�a del gastr�nomo  Eduardo Saavedra  Rambla de Catalu�a, 23  Barcelona 
Island Trading  Helen Bennett  Garden House Crowther Way  Cowes 
K�niglich Essen  Philip Cramer  Maubelstr. 90  Brandenburg 
Laughing Bacchus Wine Cellars  Yoshi Tannamuri  1900 Oak St.  Vancouver 
Magazzini Alimentari Riuniti  Giovanni Rovelli  Via Ludovico il Moro 22  Bergamo 
North/South  Simon Crowther  South House 300 Queensbridge  London 
Paris sp�cialit�s  Marie Bertrand  265, boulevard Charonne  Paris 
Rattlesnake Canyon Grocery  Paula Wilson  2817 Milton Dr.  Albuquerque 
Simons bistro  Jytte Petersen  Vinb�ltet 34  K�benhavn 
The Big Cheese  Liz Nixon  89 Jefferson Way Suite 2  Portland 
Vaffeljernet  Palle Ibsen  Smagsl�get 45  �rhus 
Wolski Zajazd  Zbyszek Piestrzeniewicz  ul. Filtrowa 68  Warszawa 

To preserve space, the table above is a subset of the Customers table used in the example below.


Try it Yourself

To see how SQL works, you can copy the SQL statements below and paste them into the textarea, or you can make your own SQL statements.

SELECT * FROM customers


SELECT CompanyName, ContactName
FROM customers


SELECT * FROM customers
WHERE companyname LIKE 'a%'


SELECT CompanyName, ContactName
FROM customers
WHERE CompanyName > 'a'

1 When using SQL on text data, "alfred" is greater than "a" (like in a dictionary). 

SELECT CompanyName, ContactName
FROM customers
WHERE CompanyName > 'g'
AND ContactName > 'g'





previous next

From http://www.w3schools.com (Copyright Refsnes Data)

Home>Manual>SQL Exercises