SQL Solutions – HackerRank Test

📌 Questions I Solved

1. Weather Analysis Solution

   • Analyzed weather data to extract meaningful insights.
   • Worked with time-series data, conditional queries, and aggregations.
   • Demonstrated skills in handling nested queries, window functions, and data filtering.

2. Crypto Market Transaction Monitoring

   • Monitored and analyzed crypto transactions for irregularities and patterns.
   • Applied advanced SQL techniques like CTEs (Common Table Expressions), ranking functions, and subqueries.
   • Focused on identifying transaction behaviors useful for risk analysis and market monitoring.

🛠️ Skills & Concepts Used

• Joins (Inner, Outer, Self Joins)
• CTEs (Common Table Expressions)
• Window Functions (ROW_NUMBER, RANK, PARTITION BY, etc.)
• Nested Subqueries
• Conditional Filtering & Aggregation
• Time-Series and Trend Analysis