Try solving these.!

Total Questions: - 74 (will keep adding as I solve them...)

  1. Olympic Gold Medals >>> Ankit Bansal
  2. Business Days Excluding Weekends and Public Holidays
  3. No of people present inside hospital
  4. Highest and Lowest Salaried emp in each dept.
  5. Start_time,End_time and Duration of calls
  6. Deriving new value based on formula
  7. Qualified or not (Ameriprise)
  8. Adult child Pair
  9. Find company only whose revenue is increasing every year
  10. Parent Child relations
  11. ICC World Cup Table
  12. Origin & Dest for each flight & New Cust each month
  13. Source & Target
  14. Movie Genre and Stars
  15. Max discounted tours for a family
  16. Busiest Route
  17. DB Case_Sensitivity Vs Insensitivity
  18. Max and Min pop City in a state
  19. Swap consecutive seat ids
  20. User Session Activity
  21. Clocked Hours
  22. Poll winnings (In proportion)
  23. First,middle,last names of cust
  24. Price_date beginning of month
  25. Brands - Fill last non null val
  26. Find Number Of Spaces in a sentance
  1. Remove Redundant Pairs >>> techTFQ
  2. Mountain Huts & Trails
  3. Footer Values
  4. Segregate Data
  5. Salary Report Generator
  6. Student Performance
  7. Find relevant dates
  8. Add Missing Values
  9. Merge Products
  10. Remove Outliers
  11. Count Employees
  12. Find Missing Data
  13. Mutual Friends
  14. Covid Cases
  15. Consecutive user logins
  16. Employee Attendance
  17. Median Age of countries
  18. Popular Posts
  19. REGEX to find valid emails
  20. Derive output products
  21. Lowest Token No
  22. Login Duration
  23. Job vacancies
  24. Passengers allowed in lift
  25. No of points of a team
  26. Present Absent
  1. Change the product_IDs >>> Data Sculptor
  2. Zomato - Item Swapping>>> Nishtha Nagar
  3. 3 Month Moving Avg (Sales) >>> Nishtha Nagar
  4. Capitalize >>> The Data-Tech Club
  5. Consecutive Events Count >>> Data Sculptor
  6. Dedup Combos >>> Data Sculptor
  7. Student_total_marks for top 2 subjects >>> DataScience corner
  8. Gaps in sequence >>> DataScience corner
  9. Numbers Game >>> Data sculptor
  10. Rewards Data >>> Data sculptor
  11. Latest_login & Capitalize >>> Sneha Kulkarni
  12. Fix the issue >>> Sneha Kulkarni
  13. Top 2 rest. in each city >>> The Data-Tech Club
  14. Name Pivot (case when) >>> The Data-Tech Club
  15. Service status logs >>> The Data-Tech Club
  16. New and repeated customers >>> Learn by doing it
  17. Map Letter and Words >>> Data Sculptor
  18. Return Dummy Data instead of Empty >>> Data Sculptor
  19. Cumulative sum without window functions >>> The Data-Tech Club
  20. Output as JSON >>> Data Sculptor
  21. License Data >>> Data Sculptor
  22. Friends Categories >>> Data Sculptor
  23. Avg Time Of Machine. >>> Data Sculptor
  24. Countries' Transactions >>> Coding Lake