Apache Friends Support Forum

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

Hi,

I cannot see any questions.

best wishes,
Altrea

"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.

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.

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;

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

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

Probably.