I read through my previous page and did my exercises. It really drives the point to make notes while learning something. Many times I will be watching the video and copying down the examples but you only know how the code works if you try it out at the exercises. I know if I have to replay the video to find out the codes example again, I will be very frustrated so luckily I had done so in my notes. I take down the definition and examples shown by the speaker. Another way I use this is as a recap resource since I learn the code every few days and obviously, I would have forgotten how the code works. Hope it will be useful to you if you found it. Here on to the next page of syntax. 1) Aggregate functions - take in multiple inputs and return a single output. AVG() -returns average value as a float (with decimal places) COUNT() - returns the number of values MAX() - returns the maximum value MIN() - returns minimum value SUM() - returns the sum of all values ROUND() - returns a rounded va
I hope to share with you my consolidated thoughts on a wide variety of topics here.