Sachin Kumar Profile picture
Jan 17 โ€ข 8 tweets โ€ข 4 min read
๐ŸŽฏ- Day 22 of SQL Series

๐Ÿงต๐Ÿ‘‡
โ“Problem Statement : @UnitedHealthGrp has a program called Advocate4Me, which allows members to call an advocate and receive support for their #health care needs โ€“ whether that's behavioural, clinical, well-being, health care financing, benefits, claims or #pharmacy help.
- Calls to the Advocate4Me call centre are categorised, but sometimes they can't fit neatly into a category. These uncategorised calls are labelled โ€œn/aโ€, or are just empty (when a support agent enters nothing into the category field).
Write a #query to find the percentage of calls that cannot be categorised. Round your answer to 1 decimal place.
๐Ÿง  Hints to Solve this Question

๐Ÿ“ Filter for uncategorised calls and count them.
๐Ÿ“ Count the total calls.
๐Ÿ“ Use the percentage formula.
๐Ÿ“ Round the output.
๐Ÿ™Œ ๐๐ข๐  ๐’๐ก๐จ๐ฎ๐ญ๐จ๐ฎ๐ญ ๐ญ๐จ Shri @NickSinghTech Sir for providing such a great Content

โ–ถ๏ธCode Snippet : Image
โ›“ Give it a try to this amazing Question & Don't Forget to Check the Previous Problem on my Profile
@Sachintukumar

๐‹๐ž๐ญ'๐ฌ ๐๐จ ๐ข๐ญ ๐ญ๐จ๐ ๐ž๐ญ๐ก๐ž๐ซ ๐Ÿ™Œ

#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLquery

datalemur.com/questions/uncaโ€ฆ

โ€ข โ€ข โ€ข

Missing some Tweet in this thread? You can try to force a refresh
ใ€€

Keep Current with Sachin Kumar

Sachin Kumar Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Sachintukumar

Jan 22
๐ŸŽฏ- Day 23 of SQL Series Project

๐Ÿงต๐Ÿ‘‡
๐Ÿง  SQL is the most important tool, a data analyst uses to manipulate and gain insights from the data. In this project, we will try to process, and analyze the data, for this purpose we will use this Zomato Datasets from Github
Read 5 tweets
Jan 21
๐Ÿ‘ฉโ€๐Ÿ’ป GitHub Importance in Data Field ๐Ÿ”…

๐Ÿงต๐Ÿ‘‡
๐Ÿ“… Data Professionals need #GitHub for source code management. It hosts Git, an open-source version control system that tracks the changes and requests of a project. Using GitHub, users can #clone the code from the central #repository to their local machine, make changes, commit
I will Tell You 3 Steps To Gather Perfect Knowledge About Github & Git

1๏ธโƒฃ W3Schools.com Tutorial
w3schools.com/git/default.asp
Read 7 tweets
Jan 20
๐Ÿ’ป Hey Folks ๐Ÿ˜€

โœ Day 5๏ธโƒฃ - Series on #Python

๐Ÿงต๐Ÿ‘‡
๐Ÿ™ ๐๐ข๐  ๐’alute ๐ญ๐จ Shri @Alex_TheAnalyst Sir for providing such a great Content

โœ In this Post I created a BMI Calculator in #Python Image
๐Ÿ“ข Github Project Link - ( Request to every learners to must check )github.com/sachinkumar160โ€ฆ

#pythonprogramming #Data #PythonbySk #100dayswithpython
#60dayswithpython #30dayswithpython
Read 4 tweets
Jan 20
๐Ÿ“Š Hey Folks

โœ So Day - 2๏ธโƒฃ on #powerbi
โš  Today I Made a Awesome Finance Dashboard

๐Ÿ”ฐ ---> ๐๐ข๐  ๐’alute ๐ญ๐จ @codebasicshub for providing such a Great Content

#powerbijobs #powerbidevelopers #powerbihiring #Powerbibysk #datascience #dataanalytics #data #portfolio #GITHUB Image
๐Ÿ“ข Github Project Link -lnkd.in/dNhVbYkJ ( Request to every learners to must check for Complete Dashboards related Data )
Read 4 tweets
Jan 9
๐—ช๐—ต๐—ฒ๐—ฟ๐—ฒ to practice SQL in ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฏ ๐Ÿ‘จโ€๐Ÿ’ป

Don't panic during your data interviews. Just use these to practice for your SQL technical assessments.

๐Ÿงต๐Ÿ‘‡
๐ŸŽฏ Datalemur - bit.ly/3VQ3nK7

๐ŸŽฏ Leetcode - bit.ly/3uqPGWl

๐ŸŽฏ Strata Scratch - bit.ly/3UynawT

๐ŸŽฏ Hacker Rank - bit.ly/3utazjT
๐ŸŽฏ SQLZoo - lnkd.in/gMRA8r-X

๐ŸŽฏ SQL Pad - lnkd.in/gUCDrjY8

๐ŸŽฏ SQL Lemur - lnkd.in/gQTuHXcQ

Credit - Shri Bemnet Girma
Read 4 tweets
Jan 8
๐ŸŽฏDay -17 on SQL Questions Series๐Ÿ““

โ–ถ๏ธToday I Solved the #Olympic Gold Medal
Problem

๐Ÿงต๐Ÿ‘‡
Q17 ) In problem where we need to find player with no of gold medals won by them only for players who won only gold medals.?
๐Ÿ““Code Snippets :
Read 4 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(