sql задача (тестовое)
Задача решить следующие задачи (начальный уровень SQL). Базу и доступы дам. Сделать до конца дня
Show all info about the employee with ID 8.
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).
Applications 1
-
1 day2 USD
229 1 day2 USD
Добрый день
Работаю с базами постоянно
Mysql
mssql
Postgres
No sql
Mongo db
Redis
-
1 day2 USD
250 13 0 1 day2 USD
Выполню до конца дня. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-
1 day2 USD
142 1 day2 USD
Сделаю ради отзыва, сертифицированный разработчик MS SQL, за часик легко
-
1 day3 USD
69 1 0 1 day3 USD
Могу помочь,
1) SELECT * FROM Employee WHERE ID=8
2) SELECT first_name, last_name FROM Employee WHERE City = "London"
Тоже учусь, так что основы немного знаю. Смотри мое портфолио там в каждом задании БД
-
1 day6 USD
94 8 1 2 1 day6 USD
Доброго дня) Готовий виконати ваше замовлення. Маю навички роботи з mySQL та PostgreeSQL.Створював бази даних для інтернет-магазину косметики і базу для оцінки рейтингу студентів за результатами залікової та екзаменаційної сесій. Пишіть на пошту [email protected]. Гарного настрою)
-
1 day9 USD
36 1 day9 USD
Есть опыт работы с Mysql.
В Приложении структура базы данных?
Кроме того Вы сбросите дамп или доступ к баае?
Напишите для уточнения на [email protected]
-
1 day9 USD
1173 110 4 1 day9 USD
Здравствуйте, готов выполнить, но нужно больше подробностей, вам нужно лишь только сами запросы?
Обращайтесь буду рад сотрудничеству.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 2 days 16 hours back ∙ 4 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 2 days 19 hours back ∙ 18 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 4 days 11 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 5 days 16 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 5 days 19 hours back ∙ 13 proposals |
Kyiv