MySQL Query Help
$10-30 USD
Paid on delivery
I have a session ID compiled from the following:
Part 1: Julian date (example: 1-365)
Part 2: 4 digit year (example: 2018)
Part 3: Meridian (example: AM or PM)
Part 4 and 5: Other ID values not related to date
Full example: 3162018-AM-1-28
I have a view that aggregates several values from several tables and is built to show data for the current date only. One of the select values is this session_id mentioned above.
In the view, I only want to show records for the session_id associated with the current date. If I use MAX(session_id) in my query, I will get older session_id if they are the newest. If I don't aggregate this data, I get repeating records. Instead, there should be a single record for each person defined with a schedule record for the given day.
-- If Part 1 and Part 2 of the session_id is <> to the current Julian date + 4 digit year, it should return as NULL.
-- If Part 1 and Part 2 of the session_id = to the current Julian date + 4 digit year, it should return the full session_id from trip_history table.
I am attaching the the source tables ([login to view URL]) and the view definition ([login to view URL]) for import and examination.
Keep in mind that the view data is date/time sensitive. There are CASE statements in the view SQL that will only allow you to see records from trip_history that were created on the current date in the AM or PM (dependent on the system time).
Project ID: #18145142
About the project
Awarded to:
Hello, I have over 7 years of experience in dealing with MySQL and other programming languages. I do need to clarify a few things so please send me a message so we can talk more. Thanks! Caleb
12 freelancers are bidding on average $27 for this job
INTRODUCTION I can see you are interested in building complex MySQL Query. I have also studied your case studies you wrote in the project description. I can create your SQL procedures, rank, percentile aggregates t More
Hey i am professionally software engineer having +3 year experience in this field i read the descriptions and understand i have lot of expertise in Database development using MS Sql Server, MySql etc having experie More
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
I'm really good at Mysql, I have 10 years of experience in mysql, java, android and other skills, I think I'm the person you need for your project, look at my portfolio
I'm full stack developer, I have worked lots of calculation related app and web application like pos,Billing systems.
Hi, I have a lot of experience in this field. Now i am currently working in TATA Consultancy Services (TCS) . Give me a chance I think i can Easily do it. Thank you .
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin More