Share this page!

Sachin Kumar Profile picture
Twitter logo
Feb 11 โ€ข 7 tweets โ€ข 12 min read
๐ŸŽฏ- Day 28 of #SQL Series ๐Ÿค–

๐Ÿ’น Today I Solved a Two Amazing Questions ๐Ÿ“™

๐Ÿงต๐Ÿ‘‡
๐Ÿ”—Q1) Problem Statement : Write a #Query to find no. of Gold Medal per swimmer for swimmer who won only Gold Medals .

#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLbySk #dataanalytics #business #sqlprogramming Image
#developer #techtwitter #technology #tech #programming #programmer #programmingmemes #SQL #sqlschooltraining #technologie #TechnologyNews #development

Q2) Problem Statement : Write a Sql to find business day between create date and Resolved date by excluding weekends and public holidays

#100daysofcodechallenge #SQLbySk #dataanalytics #sqlprogramming #sqldeveloper #sqlquery
#sqlprogramming #100daysofsql #sqlprogramming Image
#developer #techtwitter #technology #tech #programming #programmer #programmingmemes #SQL #sqlschooltraining #technologie #TechnologyNews #development

Please Check Guys This #Github Repo contain Awesome SQL Query

#development #techtwitter #SQL #programming #technology
github.com/sachinkumar160โ€ฆ

โ€ข โ€ข โ€ข

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

Sachin Kumar Profile picture
Feb 12
Are you looking to gain real-world ๐Ÿ“Šexperience in data science and analytics?

๐Ÿ”ฅ Here is a list of 10 top-notch virtual #internships with companies such as BCG, British Airways, GE, KPMG, Tata, and more.

๐Ÿงต๐Ÿ‘‡
1. KPMG Data Analytics Internship
lnkd.in/eUBvyFmd
2. BCG Data Science & Analytics
lnkd.in/e2eC27AR
Read 12 tweets
Sachin Kumar Profile picture
Feb 9
๐ŸPython is easy!

You can learn enough #Python in 8-10 hours to pick the rest up with active practice.

Here are my top 5 #free places to catch the basics:

๐Ÿงต๐Ÿ‘‡
1/ Codeacademy (where I first learnt Python) -
lnkd.in/eZnqKD_x
2/ MITx 6.0001 (this series is a brilliant intro to CS) -
lnkd.in/eeBXsQqr
Read 7 tweets
Sachin Kumar Profile picture
Feb 8
โœ Day 12 - Series on #Python ๐Ÿค– with @Sachintukumar๐Ÿ“

๐Ÿ“ข Topic of Day - " Glob Module in Python "

๐Ÿงต๐Ÿ‘‡
' With the help of the Python #glob #module, we can search for all the path names which are looking for files matching a specific pattern (which is defined by us). The specified pattern for file matching is defined according to the rules dictated by the #Unix shell.

#SQL
The result obtained by following these rules for specific pattern file matching is returned in arbitrary order in output of program While using file matching pattern we have to fulfil some requirements of the glob #module because the module can travel through the list of the file
Read 5 tweets
Sachin Kumar Profile picture
Jan 30
๐Ÿ’ก ๐Ÿฑ ๐—ฎ๐˜„๐—ฒ๐˜€๐—ผ๐—บ๐—ฒ ๐—บ๐—ฎ๐—ฐ๐—ต๐—ถ๐—ป๐—ฒ ๐—น๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—ฟ๐—ฒ๐—ฝ๐—ผ๐˜€๐—ถ๐˜๐—ผ๐—ฟ๐—ถ๐—ฒ๐˜€!

Get high-quality, curated resources from these repositories.
1๏ธโƒฃ ๐—›๐—ผ๐—บ๐—ฒ๐—บ๐—ฎ๐—ฑ๐—ฒ ๐— ๐—ฎ๐—ฐ๐—ต๐—ถ๐—ป๐—ฒ ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด (lnkd.in/g5nHPZbn)
Learn machine learning by building the algorithms from scratch.
2๏ธโƒฃ ๐——๐—ฒ๐—ฒ๐—ฝ ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—ถ๐—ป ๐—ฃ๐—ฟ๐—ผ๐—ฑ๐˜‚๐—ฐ๐˜๐—ถ๐—ผ๐—ป (lnkd.in/gUspmVM9)
Learn how companies put their deep learning systems in production.
Read 7 tweets
Sachin Kumar Profile picture
Jan 27
๐Ÿ’ป Hey Folks ๐Ÿ˜€

โœ Day 8 - Series on #Python Projects

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

โœ In this Project I Done a Algorithmic Trading using #Python

#pythonprogramming #60daysofcodechallenge #PythonbySk #100daysofcodechallenge #100dayswithpython
#60dayswithpython #30dayswithpython
๐Ÿ”— Github link for Complete Python Project Repo : github.com/sachinkumar160โ€ฆ

#pythonprogramming #60daysofcodechallenge #PythonbySk #100daysofcodechallenge #100dayswithpython
#60dayswithpython #30dayswithpython
Read 5 tweets
Sachin Kumar Profile picture
Jan 26
๐Ÿ’ป Hey Folks ๐Ÿ˜€

โœ Day 7 - Series on #Python Projects

๐Ÿงต๐Ÿ‘‡
โœ In this Post I create EDA PROJECT ON SUICIDE CASES IN INDIA
using #Python

* Find insights about - suicide due to unemployment
- #suicide cause
- #gender plays any role
-#age group mostlikely to suicide
#state having highest count
#least suicide case

github.com/sachinkumar160โ€ฆ
#pythonprogramming #60daysofcodechallenge #PythonbySk #100daysofcodechallenge #100dayswithpython
#60dayswithpython #30dayswithpython

instagram.com/datawithsachin/
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!

Send Email!

:(