Write 2 to 3 SQL. queries.
Budget: $10 – $30 USD
Hello,
I have 2 tables.I will provide you table attributes and some sample data. I would like someone to create 2-3 different ways to do the following:
For all employees in the Person table
where employee is non exempt (IS_REMOVED = FALSE from LM_PER_TRANSCRIPTS_F_V table)
get the most recent completition date for the following LOTITLE:
LOTITLE LIKE "Cyber Shield"
LOTITLE LIKE "Phishing"
LOTITLE LIKE "Foresight"
and if most recent completition date is null then mark as NA
I have 2 tables.I will provide you table attributes and some sample data. I would like someone to create 2-3 different ways to do the following:
For all employees in the Person table
where employee is non exempt (IS_REMOVED = FALSE from LM_PER_TRANSCRIPTS_F_V table)
get the most recent completition date for the following LOTITLE:
LOTITLE LIKE "Cyber Shield"
LOTITLE LIKE "Phishing"
LOTITLE LIKE "Foresight"
and if most recent completition date is null then mark as NA