Problems with the Windows version of XAMPP, questions, comments, and anything related.
by 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
by 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
-
Altrea
- AF Moderator
-
- Posts: 11935
- Joined: 17. August 2009 13:05
- XAMPP version: several
- Operating System: Windows 11 Pro x64
by 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
by 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
by 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
-
by 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
-
Altrea
- AF Moderator
-
- Posts: 11935
- Joined: 17. August 2009 13:05
- XAMPP version: several
- Operating System: Windows 11 Pro x64
by 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 122 guests