A SQL statement, I am assuming they are asking for a SQL Select statement. Select field1, field2, field3 from table1 alias1 inner (left or full) join table2 alias2 on alias1.tablekey/foreignkey = alias2.tablekey/foreignkey where (filter records based on needed filter) select field1, count(*) from table1 where group by field1 having SQL statements are based on what you need to accomplish. You have DDL and DML and then you can do other types of sql like Dynamic SQL, T-SQL, PL-SQL, or LINQ.