How would you write a query to select all teams

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How would you write a query to select all teams that won either 2, 4, 6 or 8 games?

SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8)

(Continued on next question...)

Other Job Interview Questions

• MySQL - Replication Implementation Overview
• What’s the default port for MySQL Server?
• MySQL - Replication Implementation Overview
• MySQL - Causes of Access denied Errors
• Can you save your connection settings to a conf file?
• Have you ever used MySQL Administrator and MySQL Query Browser?
• MySQL - Why So Many Open tables?
• Functionality Missing from MySQL - Stored Procedures and Triggers
• Functionality Missing from MySQL - SELECT INTO TABLE
• What is DDL, DML and DCL?
• More...