Grouping of Datetime records in MySQL

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

Hi,

I am looking for two mysql queries for the same solutions.

One query should be created with CASE WHEN THEN with no use of subqueries.

The second solution could be done as you like. Please read the attacted requirement first before you accept it. Attached is the requirement document in pdf and a mysql table which you can use as base to test your queries.

You will also see at the end of the requiremen document a screenshot that show you the used real example of searched results.

You can check / compage the results of your own query according to the screenshot in requrement document.

The same records are also to find the attached mysql table just check column Id.

MySQL SQL

Project ID: #35257811

About the project

33 proposals Remote project Active 1 year ago

Awarded to:

prdraco

Feel free to contact me for Grouping of Datetime records in MySQL .Shoot me message to discuss further more details .I provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] paym More

$50 USD in 7 days
(3 Reviews)
4.4

33 freelancers are bidding on average $140 for this job

kreativesystem91

Hello, a pleasure to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability I remain attentive to your comments Greetings

$80 USD in 1 day
(193 Reviews)
6.5
hoisticdeveloper

Hi! I am a professional coder with 11+ years of experience. I am a web expert who is well skilled for this project including MySQL and SQL. If you give me a chance, I assure you that I will give you my best . You More

$200 USD in 3 days
(39 Reviews)
6.5
mondersky

Hello, I've seen the pdf and I can start on the queries and test them before you hire me, just message me and I'll start

$50 USD in 1 day
(51 Reviews)
6.1
rohitagarberg

Hi there..i am an expert in sql Nd mysql work..have done several such project..please contact me for further discussion...you can check my profile..thanks

$100 USD in 2 days
(87 Reviews)
5.7
eduardoherreral4

Hi I have read your description carefully. ⭐ I have rich experiences in SQL, MySQL, database. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly message me. Thank you.

$100 USD in 1 day
(18 Reviews)
5.2
ishfaqrahim

Hi, this is Ishfaq Rahim! I read out your requirements and it matches my experience. let discuss further in chat. Relevant Skills and Experience: ✤ HTML5, ✤ CSS3, ✤ Bootstrap, ✤ Javascript, ✤ Jquery, ✤ Ajax, ✤ PH More

$190 USD in 7 days
(20 Reviews)
5.2
vd58xd24

⚛️ Expert for Query of MySQL For Group by DataTime Record ⚛️ Hello, I am senior developer with enough experiences on MySQL, Query, Schema, Algorithm For 7+ years. so I have confident to complete your project. I can wo More

$50 USD in 1 day
(3 Reviews)
4.1
scottwardell

Hi!>-------Full-Stack web developer is here -------< I am a senior Full-Stack web/mobile/desktop App Engineer and have enough creativity & powerful skill to finish your project on time. I have some questions to ask More

$140 USD in 7 days
(9 Reviews)
5.0
quanmeo1406

"My Query, and One Query without subquery for grouping datetime!" Hi, there. I carefully read your pdf attachment about grouping holiday datetime records in MySQL. I am pretty experienced in SQL, MySQL for 5+ years. I More

$200 USD in 7 days
(3 Reviews)
3.9
mihailsbond

Hi respected client, I hope you and your loved family are doing well. I have read your project's requirements carefully. I have rich experience of completing similar tasks several times. Being prompt and punctual is th More

$140 USD in 7 days
(4 Reviews)
3.6
Valuesolutions

Hello, I hope this finds you well. I have just seen your project requiring; SQL MySQL I believe that my 10-year experience in this field is what you need right away. Avoid the headache of looking further. Let's save More

$150 USD in 7 days
(1 Review)
3.3
vladyslavbutsei8

Hi! I have reviewed your task and I dare say that I am ready to start right now. I have read your project description and assure you that I am a perfect fit for this job because i have worked on similar projects. I am More

$90 USD in 7 days
(5 Reviews)
3.3
MilosDelic0203

Hello M. P., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on SQL, MySQL Lets connect in chat so that We di More

$140 USD in 7 days
(3 Reviews)
2.9
yevheniibelchen2

HI there. I have plenty of exp with RDBM so I am confident to deal with your job. I 've your pdf file and then I think that it is no so difficult. if you contact me, I will do my best and you will get perfect result. A More

$250 USD in 2 days
(3 Reviews)
3.1
tsmcguinness

hello. i am mysql expert having rich experience for 6+ years. please contact me. i promise the best service. thanks.

$140 USD in 7 days
(1 Review)
2.3
rixtoosterhof

Hello, How are you? I can do this job in few hours. I have rich experience in SQL query. Please send me a message so that we can dsicuss more. Thank you

$100 USD in 1 day
(3 Reviews)
2.2
AhDardear

Dear, I have reviewed your SQL queries carfully, I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified Oracle developer experienced in MySQL, Mssql, Postgres and More

$140 USD in 7 days
(2 Reviews)
2.2
terranusa

Hi. We are from PT Terra Nusa Teknologi, an IT Developer startup based in Indonesia. Throughout our years, we have experienced in multiple projects, developing web and mobile applications using front end technologies s More

$50 USD in 7 days
(6 Reviews)
2.9
maksymkhomenko1

Hello, How are you? I've checked your job description carefully and very interested in your job because I have a lot of experience in such projects before. If you give me the chance to work on your project, I can start More

$140 USD in 7 days
(2 Reviews)
1.1
amtech1410

Hello, I can start work right now,i am MERN stack developer having experience in open source languages,Node Js ,MySql,PostgreSql, mongodb etc.. Waiting for your positive reply. Thanks

$140 USD in 3 days
(1 Review)
0.8