DEV Community

Cover image for Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff
Rammina
Rammina

Posted on

Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff

Greetings, everyone!

Today, I worked on a lot of different things. I made some progress with learning SQL and Next.js as well as coding the Terms of Use page for my business site. Not too bad I'd say.

Note: The character in the thumbnail is Lena from 86.

Anyway, let's move on to my daily report!

Yesterday

I set my goals for this week, which are:

  • finish the Terms of Use and Privacy Policy pages, and then deploy them.
  • learning more SQL, Next.js, and Scrum.

Today

Next.js

SQL

  • practice doing nested SELECTs.
  • learn more about how correlated subqueries work.
  • learned how to use aggregate functions, SUM and COUNT.
  • continued to go through SQLZoo's SQL Tutorial.

Scrum

Thank you for reading! Have a good day!

Rammina Thank You Banner

Resources/Recommended Readings

DISCLAIMER

This is not a guide, it is just me sharing my experiences and learnings. This post only expresses my thoughts and opinions (based on my limited knowledge) and is in no way a substitute for actual references. If I ever make a mistake or if you disagree, I would appreciate corrections in the comments!


Other Media

Feel free to reach out to me in other media!

Rammina Logo

Twitter logo

Github logo

Top comments (0)