MySQL tutorial 9 – Count, Sum and Average

Công Nghệ

In this tutorial I show you how to use Sum, Count, and Average functions to perform calculations in MySQL.

Sponsored by DevMountain. Get yourself career ready, check out their website:
Don’t forget to tell them I sent you.

Follow me on social media:

Become a Patron:

Subscribe to my Vlog channel:

Subscribe to this channel:

Please note:
I do not offer web development services, private tutoring, or “assistance” on school or university projects. I am not an online support service, and I’m not interested in setting up a “start up” business with viewers.


Xem thêm bài viết khác:

24 thoughts on “MySQL tutorial 9 – Count, Sum and Average

  1. I was getting an error because of the space. As soon as I hit "Play" here, I paused it, went back, removed the space, came back and it worked, even so I went on watching because why not and sure enough, right after a minute you mentioned the space after "COUNT" lol little things that make you pull your hair out smh

  2. how can we save arthmetic operations between two columns in next column of same table in sql…any guides ?

  3. So hard to find good MySQL tutorials on YouTube. Glad to say I don’t have that problem anymore! I am now subscribed.

  4. Does anyone know how to use the count function to count the number of blue lightsabers for example? as opposed to counting the total product names?

  5. Ugh I can't figure out why I can't do SUMs or AVG…

    I've tried many variations, including:

    SELECT SUM('supplier_number_of_products') FROM 'supplier'

    Don't judge me on the name of column, but the column name and table is correct. The column 'supplier_number_of_products' is set as SMALLINT(4) in the structure, so I can't figure out why this aint' working…

    Anyone? 🙁

  6. Thank you Quentin! After I managed to export my dissertation dataset as a CSV file from SPSS I have been using your tutorials to run queries on my data on MyPHP. They are to the point and really helpful and i will definitely recommend.

  7. How about summing up query that has the same entry name in the table?a lot of the same entry name that i need to sum up the specific column.

  8. You say to not mess up the BRACKETS after COUNT…but those are PARENTHESIS!

    Haha just kidding. Good videos. Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *