SQL 技能测试

Test your SQL Skills
测试你的SQL技能

On this page you can test your SQL skills.
在这张页面你可以测试你的SQL技能

We will use the Customers table in the Northwind database:
我们将使用Northwind数据库中的Customers表：

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.
为了节约空间，上述表格是下面例子所使用的Customers表格的一个子集。

---

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.
为了使你明白SQL是如何工作的，你可以将下面的SQL语句复制到文本框内，或者你可以书写你自己的SQL语句。

SELECT * FROM customers

SELECT CompanyName, ContactName FROM customers

SELECT * FROM customers WHERE companyname LIKE 'a%'

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