Built-in Functions

Contest details

There is no description for the selected contest.
Allowed languages: | SQL Server prepare DB & run queries | SQL Server run skeleton, run queries & check DB |
Contest participants: 1173
Practice participants: 3023


01. Find Names of All Employees by First Name

Problem Descriptions


02. Find Names of All Employees by Last Name

03. Find First Names of All Employees

04. Find All Employees Except Engineers

05. Find Towns with Name Length

06. Find Towns Starting With

07. Find Towns Not Starting With

08. Create View Employees Hired After 2000 Year

09. Length of Last Name

10. Rank Employees by Salary

11. Find All Employees with Rank 2

12. Countries Holding 'A' 3 or More Times

13. Mix of Peak and River Names

14. Games From 2011 and 2012 Year

15. User Email Providers

16. Get Users with IP Address Like Pattern

17. Show All Games with Duration & Part of the Day

18. Orders Table

Cookies help us deliver our services. By using our services, you agree to our use of cookies. OK