Riddhi Valecha

Riddhi Valecha

  • 594
  • 2.8k
  • 252.3k

Mysql Select Query - Please Help.. Urgent

Nov 15 2019 3:11 AM

Dear Team,

I need help in making a query. PLEASE HELP AS IT IS A BIT URGENT -

My Table is -
 
IDPlaceGamePlayerSlotBookingDateStatusCreatedOnCreatedBy
1GujaratBadmintonKesarSL1530-10-2019 06:15130-10-2019 11:47Akash
2GujaratBadmintonKesarSL2130-10-2019 06:15130-10-2019 11:48Pintoo
3GujaratBadmintonAkashSL2130-10-2019 06:15130-10-2019 11:48Pintoo
4GujaratBadmintonSunilSL2130-10-2019 06:15131-10-2019 11:45Pintoo
5GujaratBadmintonAkashSL1631-10-2019 06:15131-10-2019 11:45sunil
6GujaratBadmintonPintooSL1531-10-2019 06:15131-10-2019 11:45Akash
7GujaratBadmintonSunilSL1531-10-2019 06:15131-10-2019 11:45Akash
8GujaratBadmintonPriyaSL1531-10-2019 06:15131-10-2019 11:45Akash
My Requirement is ---
 Inputs from user -
Location, Game, CreatedByUser
Steps -
1. For user Akash - check number of rows based on
createddate,
game (input from user),
place (input from user)
2. There is one row for 30-10-2019(createdon) with player Kesar.
There are three rows for 31-10-2019(createdon) with players Pintoo, Sunil, Priya
So, the output will be -
Booking Date : 30-10-2019
Slot : SL15
Game: Badminton - Singles
Players :[ Kesar ]
------
Booking Date : 31-10-2019
Slot : SL15
Game: Badminton - Doubles
Players :[ Pintoo, Sunil, Priya ]
-
How Do I make this select query?? PLEASE GUIDE.. 
 

Answers (1)