That’s me :)
Visit http://www.anatolyspektor.com to find out more about me !
Get My Book
- Fun stuff
- IT News
- My Work
- Programming Languages
Error: Twitter did not respond. Please wait a few minutes and refresh this page.
Category Archives: SQL
Case: Write a query that displays the employee’s Full Name and Job Title in the following format: DAVIES, CURTIES is Store Clerk for all employees whose last name ends with S and first name starts with C or K. Give … Continue reading
Case question: Display each employee’s last name, hire date, and salary review date, which is the first Tuesday after a year of service, but only for those hired after 1997. Label the column REVIEW DAY. Format the dates to appear … Continue reading
Here is the case: Create a query that displays the city names, country codes and state province names, but only for those cities that start on S and have at least 8 characters in their name. If city does not … Continue reading
My friend asked me how to create following SQL query: For each employee hired before 1992, display the employee’s last name, hire date and calculate the number of YEARS between TODAY and the date the employee was hired. Label the … Continue reading