Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

7 USD

Writing a SQL request is timely.

7 USD

Databases & SQL, Web Programming

6 out of 6

project complete

publication
open for proposals
terms confirmation
reservation
work underway
project complete

Project translated automatically. Log in or register, to view the original

Write a SQL request the result of which will be a list of completed orders (status - complete) with their sources (source and medium). The field in the outcome table is the order ID from the file, source and medium from the Google Analytics download. All data processing must take place in this request. As a source of data take -https://support.google.com/analytics/answer/3416091?hl=ru - instructions to create a project in BIgQuery and get access to the example table c data on visits.https://bigquery.cloud.google.com/table/google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910 - the table itself. https://storage.googleapis.com/rz_open/orders_statuses.csv - a link to the file with order status data. It needs to be downloaded into BigQuery by creating another table. The order ID file is uncommon for all of their LCH prefix (e.g. 42601631862 instead of LCH42601631862)

Client's review of cooperation with Aleksandr S.

Quality

Professionalism

Cost

Contactability

Deadlines

Operational and professional assistance. I am grateful and recommend cooperation.

Daniil Den | Safe

Freelancer's review of cooperation with Daniil Den

Payment

Task setting

Clarity of requirements

Contactability

A great customer. Always on communication, fruitful cooperation, interesting project in BIgQuery. Operational payment.

Aleksandr S. | Safe

Proposals 3

by default date online rating cost completion time

11 USD

Yury Yaremchuk

11 USD

Go to turn.

Show original

Translate

9 April 2017, 12:39

11 USD

Svetlana Vlasyuk

11 USD

I have great experience working with all versions of SQL (PL/SQL, T-SQL, SQL+), now I am a senior developer of T-SQL. If necessary, I can send examples of my code.
My skype is light.vlasjuk. I live in Kiev.

Show original

Translate

9 April 2017, 11:15

1 proposal concealed

Current freelance projects in the category Databases & SQL

Development of the web service "Interactive Veterinary Dental Map" Project essence: a web application where doctors can maintain interactive dental charts for patients (cats and dogs) The interface design and all jaw elements are already fully prepared in Figma (vector SVG with separation by individual teeth) Required functionality:… Databases & SQL, Web Programming ∙ 1 hour 42 minutes back ∙ 29 proposals
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C: 45 USD Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 hours 44 minutes back ∙ 9 proposals	45 USD
Accounting, planning, and sales system for a mushroom farm 601 USD Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 2 days 7 hours back ∙ 54 proposals	601 USD
External report 1C 8.3 — forecast of goods balances 22 USD An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 2 days 8 hours back ∙ 13 proposals	22 USD
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 2 days 20 hours back ∙ 10 proposals

Daniil Den

Kyiv 25

Writing a SQL request is timely.

Client's review of cooperation with Aleksandr S.

Freelancer's review of cooperation with Daniil Den

Current freelance projects in the category Databases & SQL

Development of the web service "Interactive Veterinary Dental Map"

Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:

Accounting, planning, and sales system for a mushroom farm

External report 1C 8.3 — forecast of goods balances

Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr