-
select name,cast(sum(case when zydd ='Good' then 1 else 0 end) as varchar(255))+' '+cast(sum(case when zydd ='Excellent' then 1 else 0 end) as varchar(255))+' '+cast(sum(case when zydd ='Medium' then 1 else 0 end) as varchar(255))+' '+cast(sum(case when zydd ='Poor' then 1 else 0 end) as varchar(255)) as zydd,cast(sum(case when jssp ='Good' then 1 else 0 end) as varchar(255))+' '+cast(sum(case when jssp ='Excellent' then 1 else 0 end) as varchar(255))+' '+cast(sum(case when jssp ='Medium' then 1 else 0 end) as varchar(255))+' '+cast(sum(case when jssp ='Poor' then 1 else 0 end) as varchar(255)) as jssp
from table.
group by name
Missing keywords?
-
select name , sum (case when zydd = 'Excellent'then 1 else 0 ) zydd excellent, sum (case when zydd ='Good'then 1 else 0 ) zydd good, sum (case when zydd ='Medium'then 1 else 0 ) zydd, sum (case when zydd ='Poor'then 1 else 0 ) zydd poor, sum (case when jssp='Excellent'then 1 else 0 ) jssp excellent, sum (case when jssp='Good'then 1 else 0 ) jssp good, sum (case when jssp='Medium'then 1 else 0 ) jssp, sum (case when jssp='Poor'then 1 else 0 ) jssp poor, from table group by name
-
1. We should help students who are poor in their studies and don't laugh at them.
2. Let each of us dedicate a piece of love to help the people in the disaster area tide over the difficulties.
3. To learn well, you must first rely on your own efforts, and the help of others is secondary.
4. At school, we received guidance and help from teachers.
5. Grandma is kind-hearted and often helps people in need.
6. If a classmate has a shortcoming, he should help enthusiastically and not be sarcastic.
7. Xiaohong often helps her neighbor Grandma Wang with housework.
8. We should not alienate students with shortcomings, but sincerely help them.
9. Don't discriminate against people who make mistakes, and be patient to help them correct their mistakes.
10. We should help those criminals who are willing to repent and turn their ways.
11. For teenagers who are confused and gone astray, we should enthusiastically help them wake up as soon as possible.
12. Teachers are always enthusiastic to encourage and help every student.
13. Mom is generous and kind to people and often helps people in need.
14. Although Aunt Wang's family life is not wealthy, she is not stingy at all in helping people in need.
-
When something is what is written in a sentence:1. When the wind gently blows through the begonia, she will shake her round little face and nod and smile at you.
2. When the wind blows, the plane tree opens its big hand to greet us.
3. When the quiet night comes, there will be stars whispering there.
4. When the spring breeze blows through the willow tree, it is like a little girl laughing.
5. When the breeze blows, the willow will dance her slender waist.
6. When I miss you, take out your blurry image and look at it.
7. When his mother started to get busy, he was quietly writing his homework on the side.
8. When the surroundings are very quiet, the crickets play the piano on this platform.
9. When the dandelion is in full bloom, the meadow turns golden.
-
You might as well ask someone else for help! Write the sentence as follows:
1. Please help me bring the dishes; Please help me get the pencil; Please help me get the eraser.
2. Please help me bring the books; Please help me get the pencil sharpener.
Expand the envy of the world:
Sentence formation about helping:
1. Grandma is very enthusiastic and kind, and she is always eager to help if there is any difficulty in the neighborhood, and everyone says that my grandma is a good person.
2. This season is when the bayberry is ripe, and the sweet and sour taste attracts visitors from all over the world to go to the orchard to pick bayberry. God also helps, the first few days ago it rained every day, but this day is sunny, but in such weather, it also takes the courage to go up the mountain to pick bayberry.
3. Stars, twinkling in the sky, twinkling and twinkling. Sometimes, when the sky is gray, the stars faintly release their faint light. At night, the earth was pitch black, and the light of the stars was insignificant.
Xingxing, so I went to ask Sister Moon to help. The earth is no longer dark, but it is still dark!
4. My principle of life is that if you still treat me as a person, I will treat you as a friend. If you don't offend me, I won't take the initiative to provoke you. You need help, I'll do what I can to help you. You scolded me openly and secretly, then I'm sorry, please stay away from me.
5. Life is like a cafeteria, without the help of the waiter, you can choose what kind of dishes you want to eat.
6. If you want to ask others for help, you must consider the problem from the other party's position. Hu Xueyan.
7. When others are in difficulty, we should take the initiative to help, and don't stand by.
8. When the aunt was stir-frying, she found that the salt was out of food and was waiting to be used, so she asked her cousin to help buy a pack of candy back, but the cousin bought a bag of sugar, which made the aunt cry and laugh.
9. A person's happiness in life is not enough to rely on moral efforts alone, we must always paint an image of our future happiness, and rely on the almighty subconscious to help achieve it. Once the subconscious mind accepts something, it will try its best to achieve it, and then you just have to wait with peace of mind.
10. If you don't sympathize with the pain of the person who fell, you will not have friends to help you when you are in trouble.
11. Today, my mother took me to this beautiful Da'an Forest Park to play, where there are beautiful flowers and green trees and grass, which looks like a garden that I really want to want. There are birds singing in the trees, cicadas helping to harmonize, and children under the trees listening quietly and carefully to this most natural symphony.
-
Father, you are a big tree that teaches us perseverance and strength to make us unforgiving.
Father, you are a beacon that illuminates the way of life so that we do not lose our way.
Father, you are an umbrella that shelters us from the wind and rain so that we can grow up healthily.
-
"0" is the hope of people who are brave enough to strive for success, "0" is the starting line to get back up after all kinds of setbacks, and "0" is the basis for not being proud after success and humbly continuing to work hard.
-
The table tennis match began, the importance of the game is extraordinary to him, you see that he has a fine sweat on his forehead, and from time to time he wipes his clothes with trembling hands, but he still has confidence in his eyes in anxiety, he bit his lip, his hand clenched and loosened from time to time, and from time to time mechanically turned his head to look at the coach and the audience, he nodded to the coach, indicating his determination--- since he came, he must play well. Sweat fell drop by drop, his brows furrowed, the intensity of the game was beyond his expectations, he shook his hand, wiped the sweat again, and started the ball again.
1. In the countryside filled with curling cooking smoke, on the seashore with rolling waves, in the fields that exude the slightest fragrance, and in the mountains where the clear stream flows, I close my eyes and feel the quietness, the quiet ...... of this silent world >>>More
Since you have given up, why be persistent! used to be so beautiful, but the final result is to let go, that can only be said to be fate! Love doesn't have to be together! Love her so much! >>>More
Alert: Study hard and make progress every day.
The trustworthy is not defeated because he is trustworthy, but because he should not be faithful to the cunning and untrustworthy. He failed because he saw the wrong person and found the wrong person. So trustworthiness itself is correct. >>>More
Writing ideas: When writing, start from the big picture, try to explain your own views or thoughts, answer questions comprehensively and in detail, and stick to the center of the problem, and fully express the content to be expressed. >>>More