₦airaland Forum

goldmines214:
I like this idea but how do I select the other columns like name from students table and subject_name from subjects table then join it to this your query.
Please help

If you’re trying to get the sum then it has to be separate query.
Selecting student. Meta data has to also be a separate query.

Meanwhile if you want to add all query in same query forget using grouped by.

Now something is even confusing about your query, if you need details about just a student then what do you need groupBy for ?

Hmmm

goldmines214:
What I am trying to achieve is that I have different students offering different subjects with the subjects scores so I was thinking I can group by the student_id and so that I can add all the subjects scores offered by a particular student

Then simply do something like

select student_id, SUM(subject_score) ...... group by student_id

It would be of the above nature, you can add the rest join but don’t add extra column that could make the return two appear different

goldmines214:
I know that but I also want to select from the students and subjects tables but if I use aggregate functions let's say max(students.fname) then it means that I will be looking for the maximum of students first name instead of all the students names.
Please How do I arrange the above query so the group by can be helpful?

For group by to work, all column you select must have exactly same content except the aggregator column.

Meanwhile in your sql statement you made no use of aggregator so why do want to use group by

To put things straight you are not aggregating anything and so you don’t need a groupBy it is as simple as that.

goldmines214:
This is the code I have written

Group by is used in conjunction with an aggregation function but with you query I don’t see how group by is helpful.

akacomedyvideo:
maybe he can afford it bro

Virtually anything is possible here online that it is in reality.

Suspect33:
SIMP at 18

You dream and breed simp
Nothing dey your head again

xana101:
Women are useless. All of them. I just gave my wife one million naira to leave and she accepted and left. The two kids are with me. if I need any girl I just call, bang and discharge u till next banging date. If I tire I end the relationship and move to the next girl. No marrying again. God saved me from the first one. A woman I did traditional, white and court wedding for go mess up with small boy. Guys I no fit love agin.

See person wey dey give another person one million?

Kaka5:
Good day everyone, I just want to ask how I can learn cloud computing on my own as a beginner to expert level. Please professionals in this field I need your answers.. Thanks in advance!

Simply start with personal development. Use YouTube and pdf but truth is you will learn beginner stuffs very well on your own. To master the craft to an understandable level you need to
1.work with the skill
2. Learn/know with someone who is already good at it.
3. Get employed in a cloud computing company.
4. Research and keep researching

The best bet you have after beginner level is 2, 1 and then 3.

If you can find someone(physical or remote) already into it just to advise you then you would go faster and when you work with it you get confident over time and the technical material from personal research make you professional

TL; DR
Start with YouTube and pdf.

Wiseandtrue:
Whether you like it or not, Sin is also a factor

whitewalker673:
I feel happy around her. She is fun to be with.

She is pretty.

This doesn’t sound anything like a logical reason because anyone can simply be this description. I think you just got infected with oneitis. Prolly she played same games you did with her and you don’t know how to handle the hot coal.

For me main time simply stay on your own thing for about a month and watch that attitude of yours if it still stay hard. If it does maybe you where not hallucinating after all. Maybe

But for a month, maintain less contact with her and spend more time on yourself and someone else, care less about what she loves. If it still stick hard then you need to actually analyze what is going on. But for now I see desperation written all over the page.

You may think you need to act or do something but here is the trick, you can only control yourself and no matter how hard you try, you can’t change what is not within your reach and one is her liking you or turning her choices. You can only change the way you start acting now and if possible do things more maturely then you stand a bigger chance. That is the game

Uzomacharles:
Well said bro...
I mostly say that when the Convo is fun and I don't say it with seriousness..
Because I don't understand myself sometimes...
Sometimes I might be happy with a girl and next time I won't even want the girl to be close to me or even want to go close to the girl....
Like 2days ago,I travelled back from school..
**you know that girl I talked to you about some time ago??
My sister told me she always ask about me if im back..
Yesterday,she came around their because she knew I was back from school .
To be honest, I didn't even act like I knew her lol (I don't know why this always happen to me even at school and it makes girls easily loose interest )I even passed there shop like 5 times and didn't look to that direction..

Well don’t do this, anytime you see her, do acknowledge her and go your way. There is no gain in stonewalling when you don’t need to, if she didn’t see you and you didn’t then go your way. It is good for your health and peace of mind to act naturally in little things of life

After 1hour or so,she decided to come in to my shop and we discussed and talked about some stuffs..
She was the one asking the question because she told me she loves guy who listen more.
I then asked her about her boyfriend and she said she's looking for a boyfriend then I replied I thought you have one,she said something again but I didn't pay more attention to that...
What do you think about this bro?
would love to hear from you

Like I said it always boils down to one thing
Do you really want to date her? Because she is single is not a reason you should take her.
If you simply feel you don’t have the time for her now then simply play it cool. Hangout with her when you only feel necessary and be on your own when you don’t feel like.

If you still like her, give it a chance and stir the water a little by showing your interest, the more she returns the favour the more you give.

It is as simple as such.

Uzomacharles:
You started the game right and now you're acting like you're a weakling....
The reason why she has been acting like a girl is because you're acting like a man...
Who told you that she might not be setting you up to make you believe she have other guys at her peek?..
Believe me,the day you start acting too loving and available to her then she might go for another alpha male better than you...
She complained to you about the other guy(SIMP)calling her because she believes you are the Alpha Male she can't control...
Wish you all the best..
I always tell girls that im never serious with them and I can break there heart and leave it for the next guy to repair......
No go catch feelings or else na for your head..
I learned alot from Harddon, Stanliwise and co..
Happy Sunday and God Bless you all

Hahahaha well said but mind

Don’t always tell girls you will break their heart at and move on at least not all, they always should know by your attitude. Meanwhile doing so could reduce your complexity. So it is better said in attitude than words

And also acting loving and available ain’t a bad thing in its own arena but the problem is it hardly ever returned so it better one trim his love he is giving according to how much he is receiving.

Happy Sunday

Plomo:
”At his club” so what then is the foolish question of asking his source of income?

While castigating the man you have tried to ignore whether what he was saying has any sense in it.

This is what is called “Tu quoque” fallacy in psychology.
Just because he partied in his Club means he can’t argue against it?

Or just because a father smoke in his childhood days means he can’t correct his son later on not to after realizing his mistakes.

Plomo:
Na two two hundred wey dem spray dey pepper people like this so?

Funny that Deji does not know the source of Cubana’s wealth. Shey he has partied once or twice at one of his clubs.

So he partied at his club means he should not speak

whitewalker673:
I want to be with her. At the same time i feel i don't.

Is this normal?

Exactly normal.
But start the rationalization with why you want to be with her let’s hear.
Can you give a little comprehensive reason?

Image123:
It's an administrative decision. There are different administrations but the same Lord.

Mtchwww

Zeal0000007:
Guys I need your help here, me and my gal have been together for 6 yrs now, I was convinced that she's the one for me, so I decided to engage her late last year, at least to show that her position in my life is not taken for granted , we have really been through hell for each other even when there was nothing she was there for me, but thank God today I'm working now.

Now for the past 2 yrs, It looks as if I have been struggling to keep her, cos we have been cohabiting since I came back from nysc. Since I came back over two yrs now she has been mishaving , she locks her phone constantly, something she never did before, even if its opened the apps are lock only her can open it, if complain abt that she will respond like why will I touch her phone, asking me who does that, to touch a woman's phone even to go to social media, and she has being subjecting me to that because I don't trust her, when we are about to sleep she put her phone on flight mode, and put it under her pillow and put her head on top. Her phone is constantly on silent mode during day time so if it rings she will determind whom to pick so I won't hear and know. We can't watch movie together as partners perhaps she afraid of who will call next ,because she knows I will give her hit.

If I manage to pick up her call she will be shivering,
We have had alot of issues because of her giving in to distractions , I'm tired of talking , I don beat her tire my hand don bend. I have told her if u don't want me again and you have seen somewhere better , open up and tell me instead of cheating that will be honorable thing to do. I don tire for this gal, if I drive her away she has no where to go. The school she's going I'm the one supporting her, her family is not giving her enough support because the don't believing in education all the know is business, and I'm the only one bearing her load and i'm not doing that because i want to marry her, i'm doing it because she needs help and she is my lover.
She doesn't want to loose me because we have really suffered together so she want to keep me as potential husband and still be playing games outside , what crime did I do to go for service so I can come back and make life better for us, cos that was when she got spoilt. I deflowered her and thats not how I left her.

I have resolved chasing her away, right now I'm in offshore , I never trusted her while I was on land is it now that I'm offshore I will trust her?

Well the issue is far from finished, you dey do gra Gra na Im make her dey hide her phone, you need not raise alarm if you plan to hunt an antelop. Any sound e don run go far

Meanwhile stop any form of domestic violence

SALLYBERRY01:
I will be detailed, as a programmer how do you learn a new language, what method do use, for instance while watching a video to learn a programming language, do you always cram the process?, if your response IS NO, you don't cram you try to understand. I have another question after trying to understand is it normal to forget the entire process?
I will be anticipating response from programmers thank you.

You shouldn’t cram code for anything. You have the internet and hard drive to find virtually all you ever needed at anytime.

Instead you try to understand, understand means to make sense of a concept and to make sense means to connect dots together. When watching a tutorial you’re most likely doing one of the following
What ?
How ?
Why?

1.What is seeing something and knowing what they are.
2. How is how you can do them for yourself. This is very important, you must learn to do things you learn on tutorial just by yourself and be able to do similar stuff on your own
3. Why did it work. A much more deeper dive into what something is really made of rather tan just the way you see them from the top.

Now when watching a video or learning something new one thing you should concentrate on is “relatability”. How close is the new knowledge to previous ones you have learned properly before ? If they are too far off you would need to somehow close the gap by doing personal research or take some step backwards and do bigger research.
If you don’t you will just not be able to connect to the video nor even be able understand half of many things they said, even if you hear them you won’t make sense of any of them.

Sometime change the video and find more relatable ones, sometime change your tutor and if possible check if the topic is something at your level

whitewalker673:
Hi,

I need advice on this bosses.
I met this grl online after a while of chatting and vibing she suddenly fell for me. Then i told her i couldn't be with her because of some personal reasons. (I wasn't too sure of my feelings at the time) so i told her we can be friends she got angry and didn't want to speak to me again.

I let her b for a while then chatted her up again now this time she replies with with one word replies like someone who is still angry. So i told her to see me just as friends nothing more she declined.

Then one dae she just came over unannounced i was suprised. After talking and laughing for hours, it was time to sleep. We smootched and all. During one of our convo that night, she told me she met a guy and she has little feelings for him and its true cos the guy kept calling her while she was at my place.

So when she left, i started thinking of everything and then i realized i actually wanted the girl in my life. Then i tried asking her out this time she told me 'We can't date' i was just like WTF, someone that has been wanting me to ask her out now doesn't want me.

I don't know what to do now as i want her in my life.

But something else is telling me to move on.

But i still want her around.

Bosses pls advice ur boy




cc: Harddon cc: uzomacharles cc: stanliwise

Get busy bro, you’re catching feeling is all.
What exactly do you want her in your life for?
Answer the question

RMoneyInTheBank:
Ozil is a weak man

Nairaland strong man how much dey your account

Lubumbashi:
How did Mourinho know she slept with everyone if he didn't sleep with her too?

nonsense

thatthickgurl:
I think I've digressed a bit and I'm only writing to myself now.
Lol

Anyways in January 2021, my life took a turning point and with some help by a code guru on nairaland, I finally started learning front end development, after 5 long years.
I love codes, whiling away at a laptop for hours gives me joy.

During my sojourn into front end, I discovered that it's, kinda of interrelated with UI/UX, so I enrolled in a training (Zuri), to learn product design (this was in April).
Few weeks down the line, NYSC happened.
I tried all my best to get posted to Lagos but it was futile, I was deployed to Plateau.

Here comes the bad news
I had to quit my job and say goodbye to my work laptop and unlimited internet (bye bye front end , bye bye UI/UX). It's been 2 months

Fake it till you make it right?
I was in search of a PPA and kinda bragged to the wrong person that I was a product designer. The man in his Innocence thought it was the same thing as graphics design, posted me to a design company, I should have corrected him but no I thought I could fake it.

This has been working well for me because luckily, the CEO of the company travelled.
I have spent two weeks in the organization which I could have used to learn the basics if I had a personal laptop and shame won't allow me tell my colleagues the truth.

My boss returned on Friday and he was informed that I had been hired, he asked if anyone had interviewed me to know my capabilities or told me to design, they replied No. He was furious
He faced me and told me we will see on Monday and I know that means I'll be interviewed on Monday.

Please what can I do ?
Because quite frankly I don't want to lose the job, it's one of the few paying PPAs in my state

Frankly tell him what you do.
The only thing you should show is that you’re ready to work. Anything you don’t know, you will always research on it.

Meanwhile better prepare and give your best shot, your biggest fear should be delivering not an interview. If they catch you in interview it is good for both you and the company.

So it better you go and give it your best
Learn from this and
Apply for where you have a background

DirtyGold:
This thread is annoying me sef

Well done captain save a hoe... if she was so great, she won't be divorced now! Fresh girls are turning 18 every single day but, your sense failed you so badly that you had to marry a single mother of two.

No sensible man throws away a good woman that gives him peace especially if they have children together. Don't worry, what her former husband saw and divorced her, you'll see it too in due time.
How you people manage your situation is your headache.

What's tha business?

Senseless post mtchewww

MasterRahl:


Cancer, heart disease, obesity, depression...these things affects the Whites a lot. Why?

You’re reading it because they have good statistics. We don’t. Does not mean we are safer

Sysdatek:
i need a laravel developer for my projects who can make changes on the sites as required. candidate must be good with laravel, php and backend development

salary ; attractive

Location of your firm would do a lot of good

Ashamy:
Thank you for the response.. I intend starting a career in ICT.

Information tech and communication is wide. What is your niche for now?

NiklauseFred:
Na wetin make this one say him wan play Nigerian league.



Mteeeeeew!

I knew someone would say this... here is it

Ashamy:
Dear all,
Please I need your sincere advice, I am interested in learning programing. I only have OND in electrical engineering, and I'm in my 30 already.....

Please do I need to be a graduate with university degree, before l could learn programing..

No you don’t but what exactly do you intend to do with programming atleast for now?

ahmedsaniadamu:
I reside in Northern Nigeria. the problem I was encountering is that people around me including my family members deos not respect the skills I am learning any more(web development.)
if they see me coding then they will start saying jobless boy you do nothing rather than just pressing computer.you better go and learn any handwort which really really discourage me seriously it even makes me feel like I am just wasting my time..
please I need your advice on what to do about it I am really depressed

What do you currently code?

goldmines214:
What I want is the correct query and php code to achieve the required result as in the image above

Pay someone to do so for you then or read up sql query.
What you need is simple JOIN
And WHERE clauses

goldmines214:
Look at the images, the last image(required result) is what I want displaying on my browser as html table while the other images are the database tables

It is simple now. Are you asking how to write the sql query?