MySQL: GROUP BY

[@BroCodez]

You can copy and paste all of the following statements if you would like to follow along in this video. P.S. Make sure you have a customers table if you're linking the foreign key on customer_id. ------------------------------------------------------------ DROP TABLE IF EXISTS transactions; CREATE TABLE transactions ( transaction_id INT PRIMARY KEY AUTO_INCREMENT, amount DECIMAL(5, 2), customer_id INT, order_date DATE, FOREIGN KEY (customer_id) REFERENCES customers(customer_id) ); INSERT INTO transactions VALUES (1000, 4.99, 3, "2023-01-01"), (1001, 2.89, 2, "2023-01-01"), (1002, 3.38, 3, "2023-01-02"), (1003, 4.99, 1, "2023-01-02"), (1004, 1.00, NULL, "2023-01-03"), (1005, 2.49, 4, "2023-01-03"), (1006, 5.48, NULL, "2023-01-03"); SELECT * FROM transactions; ------------------------------------------------------------ -- EXAMPLE 1 -- SELECT SUM(amount), order_date FROM transactions GROUP BY order_date; -- EXAMPLE 2 -- SELECT COUNT(amount), customer_id FROM transactions GROUP BY customer_id HAVING COUNT(amount) > 1 AND customer_id IS NOT NULL;

[@youneverknew_me]

I've read the article about GROUP BY but still don't understand. Your explanation is simply the best!

[@lordofdeath9247]

bro you are a treasure , thank you for existing

[@APDesignFXP]

Dude couldn’t have a better timing i just got my assignment in sql

[@zabehullahalizadeh2310]

I love your voice and the way that you teach us. Thank you Bro Code

[@zoiskiee28]

This video explained it so much better than the first one I saw, thank you.

[@maxlin3931]

FINALLY an explanation that i understand. Thanks!

[@MDMushu-ff5od]

Just like wowww

[@stupidstone4780]

You are a god much love from IT student from serbia

[@israelcyrus2586]

love u bro from Tamilnadu.

[@alamzia2905]

what a top notch explanation sir.

[@abundance2616]

Thanks a lot for explaining it so nicely

[@thebettertwin6910]

Thank you, great explanation

[@pravinv_]

we can use where Clause also. Give the Where clause above the GroupBy Clause.But for Aggregate functions we need to use Having within Groupby

[@olufemiolawale3848]

Well explained.

[@YoshiGG_]

thank you brocode Another day Another Victory for the ogs

[@celineharakee]

life saver, I owe u my life

[@kin_1997]

you are the best

[@mdfaisalmahamud]

Love From Bangladesh 🇧🇩

[@Blizz-rm6ec]

thank you i have an asessment tomorrow it helped a lot

[@RxxxQueen]

I love you, thank you 😭😭

[@offlinemoe]

Thank you, it helped me a lot

[@ned7757]

Your videos have really helped me. I really appreciate it!

[@gabrielodiase7357]

God bless you bro

[@jaishriram6602]

Having clause can be used as a substitute for the where clause, in case we are using group by clause.

[@DarkSoulGaming7]

Love from TN too , India!

[@keroro3187]

Thank you very much

[@ilijapopovic1826]

Love you bro

[@hackerexploit8957]

Please make a bash & powershell series too 😊

[@maisie2735]

THANK YOU 😭

[@Personal1123-et3bb]

Thanks

[@stanhe9922]

u the goat

[@TvideosTv]

THANK YOU SO MUCH AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

[@shawnchristophermalig4339]

Can you make a video, explaining the math or innerworkings of GROUP by? I think what others seemed to get confused about group by is the fact that the math isn't mathin'. I mean that you visualize select, but it's hard to visualize into thinking the group by. :) Questions like: is it correct that 2 invisible became a pattern marker for group by? Something like that! 😁

[@itz_phil5146]

Are you able to do more videos about javaFX?

[@shortsShowcase250]

Can we use DISTINCT instead of GROUP BY

[@vaibhavsinhbihola1]

Hey I am also using MySQL workbench mine text editor is not same as you how I can changed it to dark and like you

[@QURAN_010]

I like your voice bro *_^

[@sidneywolfe9260]

𝓅𝓇𝑜𝓂𝑜𝓈𝓂

[@reema5315]

Would you marry me?

[@fredianriko5648]

could you please share the sql dump so we could also practice with the exact data you have?