Ukończone

SQL script

The data set has the following format(see attached):

Where agent code is a cookie ID and second column represents the comma separated segments IDs.

To-does:

1. Split segment IDs by the comma

2. Count Distinct unique agent codes that belong to each segment

3. Group and count agent codes by segment

4. And pull count data for the given range '2018-09-01' AND '2018-09-07'

Umiejętności: Microsoft SQL Serwer, MySQL, PHP, Architektura oprogramowania, SQL

Zobacz więcej: sql script tutorial, sql scripts for dummies, t-sql script examples, sql script vs query, oracle sql script example, useful sql scripts, sql scripts examples, writing sql scripts, import data access sql script, sql script count record sequence row, sql script import text website, create sql script, mmorpg php sql script text based, sql script calculate totals, sql script database changes, oracle script naar sql script, cms class sql script create php simple page, script php show online players count server warcraft, google data finance sql script, auto installer sql script

O pracodawcy:
( 0 ocen ) San Francisco, United States

Numer ID Projektu: #17737399

Przyznany użytkownikowi:

psranjana

Could you please let me know if the script is to be written with SQL server syntax or MySQL syntax? Cheers, Ranjana

$30 USD w 1 dzień
(1 Ocena)
2.2

5 freelancerów złożyło ofertę na kwotę $32 do tego projektu

limillion819

Hello sir. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. SQL is a very friendly language for me and in just some days, you'll get a wonderfu Więcej

$50 USD w ciągu 1 dnia
(9 Oceny)
3.5
harinattuva

I am expert in SQL and having 11 years of experience in MS SQL Server. 11.5 years of IT experience in analysis, design, development and Więcej

$30 USD w ciągu 1 dnia
(0 Oceny)
0.0
$25 USD w ciągu 1 dnia
(0 Oceny)
0.0
GoodwinAntony95

I have experience in SQL SERVER because this is our back end. I will do this.

$25 USD w ciągu 1 dnia
(0 Oceny)
0.0