Publish your project for free and start receiving offers from freelance contractors in serveral minutes after publication!

SQL задание (тестовое)

closed without completion


Задача решить следующие задачи (начальный уровень SQL). Базу и доступы дам. Сделать до конца пятницы.

  1.  Show all info about the employee with ID 8.



  1. Show the list of first and last names of the employees from London.



Show the list of first and last names of the employees whose first name begins with letter A.



Show the list of first, last names and ages of the employees whose age is greater than 55. The result should be sorted by last name.



Calculate the count of employees from London.



Calculate the greatest, the smallest and the average age among the employees from London.



Calculate the greatest, the smallest and the average age of the employees for each city.



Show the list of cities in which the average age of employees is greater than 60 (the average age is also to be shown)



Show the first and last name(s) of the eldest employee(s). Use a subquery.



Show first, last names and ages of 3 eldest employees.



Show the list of all cities where the employees are from.



Show first, last names and dates of birth of the employees who celebrate their birthdays this month.



Show first and last names of the employees who used to serve orders shipped to Madrid.



Show first and last names of the employees as well as the count of orders each of them have received during the year 1997 (use left join).



Show first and last names of the employees as well as the count of their orders shipped after required date during the year 1997 (use left join).



Show the count of orders made by each customer from France.



Show the list of french customers’ names who have made more than one order (use grouping).


Make a proposal!

The client doesn't want to make prepayment? Offer him to make a payment via Safe to avoid possible fraud.

Client
Максим Даву
Ukraine Kyiv  7   0
Project published
10 December 2015
206 views
Payment methods
Share