Simple SQL query script to auto populate

  • Estado: Closed
  • Premio: $10
  • Propuestas recibidas: 5
  • Ganador: HikaruGenji

Resumen del concurso

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.

Habilidades recomendadas

Comentarios del empleador

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

Imagen del perfil jackhammerunext, United Kingdom.

Principales propuestas de este concurso

Ver más participaciones

Tablero de aclaración pública

  • jackhammerunext
    Organizador del concurso
    • 4 años atrás

    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.

    • 4 años atrás
    1. HikaruGenji
      HikaruGenji
      • 4 años atrás

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

      • 4 años atrás

Cómo comenzar con los concursos

  • Publica tu concurso

    Publica tu concurso Fácil y rápido

  • Recibe montones de propuestas

    Consigue toneladas de propuestas De todo el mundo

  • Elige la mejor propuesta

    Elige la mejor propuesta ¡Descarga fácilmente los archivos!

Publica un concurso ahora o únete a nosotros hoy