MariaDB MySQL Questions

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MariaDB MySQL Questions

Postby InuKik » 10. October 2016 19:52

Hi, I am struggling with some questions and hoping if someone could help me out by solving them. I added the link for the ER Diagram and tables below with the question. Thanks in advance.

Coincidence. Have two guests with the same surname ever stayed in the hotel on the evening? Show both last and first name. No duplicates.

http://imgur.com/a/eIO50
InuKik
 
Posts: 3
Joined: 10. October 2016 19:30
XAMPP version: 5.5.24
Operating System: Windows 10 Enterprise

Re: MariaDB MySQL Questions

Postby Altrea » 11. October 2016 11:40

Hi,

I cannot see any questions.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MariaDB MySQL Questions

Postby InuKik » 11. October 2016 12:38

"Coincidence. Have two guests with the same surname ever stayed in the hotel on the evening? Show both last and first name. No duplicates."

That's the question. Thank you.
InuKik
 
Posts: 3
Joined: 10. October 2016 19:30
XAMPP version: 5.5.24
Operating System: Windows 10 Enterprise

Re: MariaDB MySQL Questions

Postby InuKik » 11. October 2016 13:01

And also it's SELECT statement. So it might be something like, SELECT DISTINCT first_name, last_name FROM guest

But I don't know how to continue from there with the answer.
InuKik
 
Posts: 3
Joined: 10. October 2016 19:30
XAMPP version: 5.5.24
Operating System: Windows 10 Enterprise

Re: MariaDB MySQL Questions

Postby studio_two » 11. October 2016 14:39

Maybe something similar to:
select last_name as AA, check_in_date as BB
from guest
group by last_name, check_in_date
having COUNT(slcust_no) >2
order by last_name;
studio_two
 
Posts: 11
Joined: 28. June 2010 15:01
Location: UK
XAMPP version: 5.6.12
Operating System: Windows 7 Professional

Re: MariaDB MySQL Questions

Postby Altrea » 11. October 2016 15:35

I cannot see how this can be a XAMPP for Windows issue.
Seems to me like homework help.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MariaDB MySQL Questions

Postby studio_two » 11. October 2016 15:45

Altrea wrote:I cannot see how this can be a XAMPP for Windows issue.
Seems to me like homework help.


Probably. :)
studio_two
 
Posts: 11
Joined: 28. June 2010 15:01
Location: UK
XAMPP version: 5.6.12
Operating System: Windows 7 Professional


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 28 guests