Complex SQL queries
-
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
-
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
-
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
Sure, try implementing a Turing Machine in SQL.
You'll never get very far if all you do is follow instructions.
-
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
data modeling guy wrote:
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
- Calculate reputation points of a user.
- Fetch the contibutions-section for a user (see the section on your user-page; it contains some statistics)
- Fetch the ten members from the database that answered most questions last month.
- Fetch the voting-percentages for the straw-poll result for all possible answers.
- Fetch any low-repuation member that posts the same message in multiple places, ordered by the amount of similar messages.
- Fetch the data to show the forum-content for page 3 of this forum, in threaded view, with 50 posts per page.
:rolleyes:
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
data modeling guy wrote:
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
- Calculate reputation points of a user.
- Fetch the contibutions-section for a user (see the section on your user-page; it contains some statistics)
- Fetch the ten members from the database that answered most questions last month.
- Fetch the voting-percentages for the straw-poll result for all possible answers.
- Fetch any low-repuation member that posts the same message in multiple places, ordered by the amount of similar messages.
- Fetch the data to show the forum-content for page 3 of this forum, in threaded view, with 50 posts per page.
:rolleyes:
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
No no no these suggestions expect him to do the work and write the queries, it sounds like he wants YOU to write the queries and he will study them. Good luck getting CM to lend out the database and schema :laugh:
Never underestimate the power of human stupidity RAH
-
Start at http://www.w3schools.com/sql/[^].
Thanks
-
Sure, try implementing a Turing Machine in SQL.
You'll never get very far if all you do is follow instructions.
Thanks
-
data modeling guy wrote:
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
- Calculate reputation points of a user.
- Fetch the contibutions-section for a user (see the section on your user-page; it contains some statistics)
- Fetch the ten members from the database that answered most questions last month.
- Fetch the voting-percentages for the straw-poll result for all possible answers.
- Fetch any low-repuation member that posts the same message in multiple places, ordered by the amount of similar messages.
- Fetch the data to show the forum-content for page 3 of this forum, in threaded view, with 50 posts per page.
:rolleyes:
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
Thanks Eddy. I Did some more google search and found some more. Cheers!
-
Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.
Get Joe Celko's Puzzles and Answers[^]
Wrong is evil and must be defeated. - Jeff Ello[^]