Simple SQL query script to auto populate

  • Stare: Closed
  • Premiu: $10
  • Intrări primite: 5
  • Câștigător: HikaruGenji

Sumarul concursului

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.

Aptitudinile recomandate

Winner
Concurs Prezentat
Postează un concurs similar

Feedback de la Angajator

“The freelancer understood the requirement clearly and was professional to test before delivering.”

Imagine de profil jackhammerunext, United Kingdom.

Cele mai bune intrări pentru acest concurs

Vezi mai multe intrări

Panoul public de clarificare

  • jackhammerunext
    Titularul concursului
    • acum 4 ani

    there will be any number of years in the future like 2021, 2022, etc or entries could be added for previous years like 2016, 2015, etc. and there could be any company coming from any country for any event.

    • acum 4 ani
    1. HikaruGenji
      HikaruGenji
      • acum 4 ani

      Thanks for the clarification. My solution is built upon these very assumptions and i have made a new entry to show case this capability.

      • acum 4 ani

Cum să începi concursurile

  • Postează-ţi concursul

    Postează-ți concursul Rapid și ușor

  • Obține o mulțime de intrări

    Obține o mulțime de intrări Din întreaga lume

  • Premiază cea mai bună intrare

    Premiază cea mai bună intrare Descarcă ușor fișierele

Postează un concurs chiar acum sau înregistrează-te astăzi!