Analysis of data using SQL
22 USD1 Understanding which self-service devices have long been without connection
2 Which segment of the network was worse affected due to the fall in the connection to the US
3 Understanding which self-service devices have been unconnected for the longest time, provided that the life of the incident (TST_Cases file) should not be taken into account in the non-connection indicators
4 Which segment of the network was more affected due to the fall in the connection to the US, taking into account the incidents
5 In which segment the highest number of incidents
In which segment of the network which user closed the most of the incidents
7 At what point of time is observed the "explosion" of the falls of the U.S. by connection, in general
8 At what point of time is observed a "explosion" of U.S. falls by connection, by segments
The solution to the task is SQL requests and the results of their execution.
По предоставленным файлам необходимо выполнить анализ с целью:
1 Понимания какие устройства самообслуживания дольше всех были без с связи
2 Какой сегмент сети сильнее пострадал из-за падения в нём связи на УС
3 Понимания какие устройства самообслуживания дольше всех были без с связи, при условии, что время жизни инцидента (файл TST_Cases) не должно быть учтено в показателях отсутствия связи
4 Какой сегмент сети сильнее пострадал из-за падения в нём связи на УС, с учётом инцидентов
5 В каком сегменте наибольшее количество инцидентов
6 В каком сегменте сети какой юзер больше всех закрыл инцидентов
7 В какой момент времени наблюдается "всплеск" падений УС по связи, в целом
8 В какой момент времени наблюдается "всплеск" падений УС по связи, по сегментам
Решением задачи являются SQL запросы и результаты их выполнения.
Applications 2
Current freelance projects in the category Databases
Website store
306 USD
Create a website, preferably on WP/OpenCard (or similar). The idea of the site is a store, the first page visually displays icons of all product categories 30+-, (and some have subcategory pages) and when clicked, we end up on the page for the selected category of products.… PHP, Databases ∙ 11 proposals |
Viber community parser
25 USD
write a parser for Viber communities following the example of the parser's work on the website https://promouser.com/ as a result, we get a file with phone numbers of community members Databases, Data parsing |
Web applicationIt is necessary to expand the functionality of the existing web application (TypeScript, React, and Next.js) by adding a fuzzy search module. The databases are large, Elasticsearch or Manticore Search should be implemented for data indexing. Databases, Web programming ∙ 5 proposals |
Develop a mobile application. Backend + Frontend Android/iOSA design has been developed. An application-catalog with user registration, filters, search, the ability to add to saved and comparison. cracking of requests from the state website (most likely parsing), a feed of recommendations based on interests, push notifications. A… Databases, Hybrid mobile apps ∙ 18 proposals |
Development of database architecture
501 USD
Database Architecture Development Description: We are looking for an experienced database architect to conduct an analysis of our current database architecture and develop recommendations for its improvement. Our goal is to optimize performance, ensure scalability, and enhance… Databases ∙ 6 proposals |