Day 92 of Learning MERN Stack

Hello Dev Community! 👋

It is officially Day 92 of my 100-day backend and database engineering sprint! 🎯 Yesterday, I tackled complex string transformations like "The PADS". Today, I focused heavily on scoped mathematical computations and structural filters on HackerRank by mastering: Targeted Data Aggregations (COUNT and AVG) combined with strict Attribute Filtering! 📊🔢

When building management portals or dashboard systems—like computing localized vendor counts or evaluating the average rating metrics of a specific category—knowing how to scope analytical operations precisely is vital.

---

🧠 Unpacking Day 92 Core Problem-Solving Logic

As visible across my script files inside "Screenshot (201).png" and "Screenshot (202).png", I built dedicated sandbox scenarios locally to examine the compilation performance of these metrics:

1. Scoped Volume Tracking: The COUNT Aggregator

• The Challenge: Query the total number of cities in the CITY table where the district field matches specifically with 'California'.
• The Code: Instead of loading full row logs, the query optimizes data transfer by executing a high-performance count directly on the indexed elements:

sql
SELECT COUNT(NAME) 
FROM CITY 
WHERE DISTRICT = 'California'; SELECT AVG(POPULATION) 
FROM CITY 
WHERE DISTRICT = 'California';