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