You have a privilege to create a quiz (QnA) related to this subject and obtain creativity score...
Testing the section Java And Databases with a set of QnA
Before starting the QnA section, please try to solve one small SQL problem and come up with another one.
Here is the problem to solve:
There is a table with two columns: Name | Activity
For example:
Name | Activity
n1 | a3
n2 | a2
n1 | a56
Was it clear so far? Highlight the text in question
Or
etc...
Please provide SQL for example for MySQL DB to display the names with corresponding number of activities, ordered by names who have more activities.
For example, the result can look like:
Name | Number of activities
n5 | 45
n3 | 44
.....
Email your solution to dean@ituniversity.us
Then think of another problem that you could offer and when invent a good one send to the same address.
Only after that start your QnA session.
We offer a fun way to share your experience and be rewarded. You create a puzzle - quiz with a good question and several answers, one correct and several wrong ones. The question as well as answers can include text, links, video. This is your creation, completely up to your taste, humor, and of course your knowledge. If there is an existing quiz above, you need first to solve the puzzles and evaluate the quality (at the bottom of every quiz). After finishing the existing quiz you will be able to create your own. The best puzzles will be rewarded!
We invite you to create your own questions and answers (QnA) to increase your rank and win the Top Creativity Prize!