Ghulam Murtaza Portfolio

4️⃣ Timestamp and temperature of highest recorded temperature for each device.

5️⃣ Devices where temperature increased from minimum to maximum recorded.

6️⃣ Exponential moving average of temperature for each device (limited to 10 devices).

7️⃣ Timestamps and devices with carbon monoxide levels exceeding average.

8️⃣ Devices with highest average temperature recorded.

9️⃣ Average temperature for each hour of the day across devices.

🔟 Device(s) with only a single distinct temperature value.

1️⃣1️⃣ Devices with highest humidity levels.

1️⃣2️⃣ Average temperature for each device, excluding outliers.

1️⃣3️⃣ Devices that experienced sudden change in humidity (>50% difference) within 30 minutes.

1️⃣4️⃣ Average temperature for each device during weekdays and weekends.

1️⃣5️⃣ Cumulative sum of temperature for each device, ordered by timestamp (limited to 10 records).

🌍 Global COVID-19 Numbers: Total cases, deaths, and death percentage.

🌍 Population vs. Vaccinations: Examine vaccination rates relative to population.

🔄 CTE Usage: Simplify complex queries with Common Table Expression (CTE).

🔄 Using Temporary Table: Store data for further analysis.

👓 Creating a View: Simplify querying using "PercentPopulationVaccinated" view.

4️⃣ Calculated total revenue generated by the Google Play Store through app purchases.

5️⃣ Determined the category with the highest number of installs and total installs.

6️⃣ Analyzed the genre with the most published apps.

7️⃣ Provided a list of games ranked by installs.

8️⃣ Counted the number of free and paid apps.

9️⃣ Identified the best dating app based on the highest number of reviews.

🔟 Compared reviews with positive and negative sentiment for the app "10 best foods for You."

1️⃣1️⃣ Extracted comments for ASUS SuperNote with sentiment polarity and subjectivity both equal to 1.

1️⃣2️⃣ Extracted neutral sentiment reviews for the app "Abs Training-Burn belly fat."

1️⃣3️⃣ Extracted negative sentiment reviews for Adobe Acrobat Reader with sentiment polarity and subjectivity...

3️⃣ Top 5 songs with the highest EnergyLiveness ratio.

4️⃣ Platform analysis for Black Eyed Peas' tracks.

5️⃣ Most liked Gorillaz song on YouTube with Energy and Tempo data.

6️⃣ Prominence of album types on Spotify.

7️⃣ Selection of top 5 songs for Spotify's announcement.