Simple SQL query script to auto populate
- Stanje: Closed
- Nagrade: $10
- Prejetih vnosov: 5
- Zmagovalec/ka: HikaruGenji
Navodila natečaja
Hi attached is a sample dataset.
Need a sql query to automate (populate) the tenure field with Year 1, 2 ,3 or 4 according to the attending companies. Currently this field has dummy data to explain what should be next in record. For example when the Event, Company Name and Country fields are entered, the tenure field should look at these columns to then populate Year.
Event Country, Company and Company Country (the first three columns) are the combination that should be looked at to calculate.
Priporočene spretnosti
Delodajalčev feedback
“The freelancer understood the requirement clearly and was professional to test before delivering.”
jackhammerunext, United Kingdom.
Najboljši vnosi tega natečaja
-
HikaruGenji Luxembourg
-
Hitesh27111991 India
-
kam1789 India
-
blui88 India
Javna tabla za pojasnila
Kako začeti z natečaji
-
Objavi svoj natečaj Hitro in preprosto
-
Prejmi na tisoče vnosov S celega sveta
-
Dodeli natečaj najboljšemu vnosu Prenesi datoteke - Preprosto!