Manipulation of SQL data
8 USD 1) For each match to be given:
the id,
The match date,
The team1_id
The team2_id
Number of points (3 - win, 1 - null) team 1 for the previous 5 matches,
Number of points (3 - win, 1 - null) team 2 for the previous 5 matches,
Number of points (3 - win, 1 - null) team 1 for the previous 5 matches in guests,
Number of points (3 - win, 1 - null) Team 1 for the previous 5 matches at home
2) for each team that played more than 20 matches in 2017 to indicate:
ID of the team,
id of the match (matches only of 2017),
The match date,
intat index of this team in the current match,
change of the intat index of that team in the current match relative to its previous match
You need to postgresql.
Applications 1
Client's review of cooperation with Olga Matsyuk
Manipulation of SQL dataExcellent work done in the shortest time!
I strongly recommend working with this executive.
Freelancer's review of cooperation with client
Manipulation of SQL dataClear TZ, fast feedback. Responsible customer, I recommend.
-
Winning proposal1 day8 USD
178 1 0 Winning proposal1 day8 USD
She worked for 2 years with POSTGRESQL in a Israeli company. I will take and fulfill these tasks without problems.
Current freelance projects in the category Databases & SQL
Resolve the loading issue on the PrestaShop website hosting
The website requires more and more resources each month. The host's response: During the server check, increased load from the MySQL database server was recorded. At times of the 500 error, the MySQL process uses a significant portion of CPU resources, which can lead to unstable… PHP, Databases & SQL ∙ 1 hour 3 minutes back ∙ 9 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 2 hours 33 minutes back ∙ 12 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 4 hours 30 minutes back ∙ 30 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 5 hours 35 minutes back ∙ 7 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 1 day back ∙ 16 proposals |