• Home
  • SQL Server
    • Articles
    • T-SQL Puzzles
    • Output Puzzles
    • Interview Questions
    • Performance Tuning
    • SQL SERVER On Linux
    • Resources
  • SSRS
    • SSRS Articles
    • Interview Questions
  • SSAS
    • SSAS Articles
    • DAX
  • SQL Puzzles
  • Interview Questions
    • SQL Interview Questions
    • Data Interview Questions
  • Python Interview Puzzles
  • New Features(SQL SERVER)
    • SQL SERVER 2017
    • SQL SERVER 2016
    • SQL SERVER On Linux
  • Social
    • Expert Exchange
      • Top Expert in SQL
      • Yearly Award
      • Certifications
      • Achievement List
      • Top Expert of the Week
    • HackerRank (SQL)
    • StackOverflow
    • About Me
      • Contact Me
      • Blog Rules

Improving my SQL BI Skills

Improving my SQL BI Skills

Tag Archives: python faaan coding interview

Python | The Print and Divide Puzzle

30 Friday Oct 2020

Posted by Pawan Kumar Khowal in Python

≈ Leave a comment

Tags

Python Coding Interview, python faaan coding interview, Python Interview Questions, Python Puzzles Python Puzzles


Python | The Print and Divide Puzzle

In this puzzle you have to print numbers up to a certain range in descending order. If the number is divisible by 5 and 3 print “Pawan Here”, If the number is divisible by 5 print “Here” and If the number is divisible by 3 print “Pawan”

Sample Input List

--

i = 1 - 20 ( range )

--

Output

--

Here
19
Pawan
17
16
Pawan Here
14
13
Pawan
11
Here
Pawan
8
7
Pawan
Here
4
Pawan
2
1

--

Solution

--

for i in range(20,0,-1):
if i % 15 == 0:
print ("Pawan Here")
elif i % 5 == 0:
print ("Here")
elif i % 3 == 0:
print ("Pawan")
else:
print (i)

--

Output

--In Python3

Here
19
Pawan
17
16
Pawan Here
14
13
Pawan
11
Here
Pawan
8
7
Pawan
Here
4
Pawan
2
1

--

Enjoy πŸ™‚

Please add a comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
β˜› Python Puzzles https://msbiskills.com/list-of-python-coding-interview-puzzles/
β˜› SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
β˜› SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
β˜› SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
β˜› SQL Server Articles https://msbiskills.com/t-sql/
β˜› SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Python | Count consecutive 1’s from a list of 0’s and 1’s

30 Friday Oct 2020

Posted by Pawan Kumar Khowal in Python

≈ Leave a comment

Tags

Python Coding Interview, python faaan coding interview, Python Interview Questions, Python Puzzles, Python Puzzles Python Puzzles


Python | Count consecutive 1’s from a list

In this puzzle you have to Count consecutive 1’s from a list

Sample Input List

--

a = [1,0,0,0,0,1,1]

--

Output

--

2

--

Solution

--

a = [1,0,0,0,0,1,1]

b1 = 0
m = 0

for i in range(len(a)):
if a[i] == 1:
m = m + 1
else:
if m > b1:
b1 = m
m = 0

if m > b1:
print m
else:
print b1

--

Output

--In Python3

2

--

Enjoy πŸ™‚

Please add a comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
β˜› Python Puzzles https://msbiskills.com/list-of-python-coding-interview-puzzles/
β˜› SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
β˜› SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
β˜› SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
β˜› SQL Server Articles https://msbiskills.com/t-sql/
β˜› SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Python | How to convert a number into a list of its digits

26 Monday Oct 2020

Posted by Pawan Kumar Khowal in Python

≈ Leave a comment

Tags

Python Coding Interview, python faaan coding interview, python faaang coding interview, Python Interview Questions, Python Puzzles


Python | How to convert a number into a list of its digits

In this puzzle you have to convert an INT value to a list of digits

Sample Input List

--

a = 123

--

Output

--

[1, 2, 3]

--

Solution

--

a = 123
k = str(a)
b = []

for i in range ( 0 , len(k) ):
        b.append(int(k[i]))
        
print(b)


--

Output

--In Python3

[1, 2, 3]

--

Enjoy πŸ™‚

Please add a comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
β˜› Python Puzzles https://msbiskills.com/list-of-python-coding-interview-puzzles/
β˜› SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
β˜› SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
β˜› SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
β˜› SQL Server Articles https://msbiskills.com/t-sql/
β˜› SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Python | Validate an IP Address-IPV6(Internet Protocol version 6)

26 Monday Oct 2020

Posted by Pawan Kumar Khowal in Python

≈ Leave a comment

Tags

Python Coding Interview, python faaan coding interview, python faaang coding interview, Python Interview Questions, Python Puzzles


Python | Validate an IP Address-IPV6

In this puzzle you have to accept an string and validate it for IPV6

Sample Input List

--

ipv6p('1001:0:11a2:52f8:2c78:818:ccf1:9a3a')

--

Output

--

1

--

Solution

--

def ipv6p(strs):
    chrs = '0123456789abcdefABCDEF'
    if strs.count(':') == 7:
        nums = strs.split(':')        
        for x in nums:
            if len(x) == 0 or len(x) > 4 or not all(c in chrs for c in x):
                return 0
            
        return(1)
    else:
        return(0)   


--

Output

--In Python3

1

--

Enjoy πŸ™‚

Please add a comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
β˜› Python Puzzles https://msbiskills.com/list-of-python-coding-interview-puzzles/
β˜› SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
β˜› SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
β˜› SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
β˜› SQL Server Articles https://msbiskills.com/t-sql/
β˜› SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Python | Print the first non-recurring element in a list

26 Monday Oct 2020

Posted by Pawan Kumar Khowal in Python

≈ Leave a comment

Tags

Python Coding Interview, python faaan coding interview, python faaang coding interview, Python Interview Questions, Python Puzzles


Python | Print the first non-recurring element in a list

In this puzzle you have to print the first non-recurring element in a list

Sample Input List

--

a = [1, 1, 1, 2, 2]

--

Output

--

2

--

Solution

--

a = [1, 1, 1, 2, 2]

k = min(a,key=a.count)

print (k)


--

Output

--In Python3

2

--

Enjoy πŸ™‚

Please add a comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
β˜› Python Puzzles https://msbiskills.com/list-of-python-coding-interview-puzzles/
β˜› SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
β˜› SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
β˜› SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
β˜› SQL Server Articles https://msbiskills.com/t-sql/
β˜› SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email
← Older posts

Blog Stats

  • 1,084,786 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,131 other subscribers

Pawan Khowal

502 SQL Puzzles with answers

Achievement - 500 PuzzlesJuly 18, 2018
The big day is here. Finally presented 500+ puzzles for SQL community.

200 SQL Server Puzzle with Answers

The Big DayAugust 19, 2016
The big day is here. Completed 200 SQL Puzzles today

Archives

March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Oct    

Top Articles

  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…

Archives

  • October 2020 (29)
  • September 2018 (2)
  • August 2018 (6)
  • July 2018 (25)
  • June 2018 (22)
  • May 2018 (24)
  • April 2018 (33)
  • March 2018 (35)
  • February 2018 (53)
  • January 2018 (48)
  • December 2017 (32)
  • November 2017 (2)
  • October 2017 (20)
  • August 2017 (8)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (18)
  • January 2017 (2)
  • December 2016 (5)
  • November 2016 (23)
  • October 2016 (2)
  • September 2016 (14)
  • August 2016 (6)
  • July 2016 (22)
  • June 2016 (27)
  • May 2016 (15)
  • April 2016 (7)
  • March 2016 (5)
  • February 2016 (7)
  • December 2015 (4)
  • October 2015 (23)
  • September 2015 (31)
  • August 2015 (14)
  • July 2015 (16)
  • June 2015 (29)
  • May 2015 (25)
  • April 2015 (44)
  • March 2015 (47)
  • November 2012 (1)
  • July 2012 (8)
  • September 2010 (26)
  • August 2010 (125)
  • July 2010 (2)

Article Categories

  • Analysis Services (6)
    • DAX (6)
  • Data (2)
    • Data warehousing (2)
  • Integration Services (2)
  • Magazines (3)
  • Python (29)
  • Reporting Services (4)
  • SQL SERVER (820)
    • Download SQL Interview Q's (212)
    • SQL Concepts (323)
    • SQL Performance Tuning (155)
    • SQL Puzzles (331)
    • SQL SERVER 2017 Linux (6)
    • SQL Server Interview Questions (308)
    • SQL SERVER Puzzles (332)
    • T SQL Puzzles (547)
    • Tricky SQL Queries (439)
  • UI (30)
    • ASP.NET (5)
    • C# (13)
    • CSS (9)
    • OOPS (3)
  • Uncategorized (5)

Recent Posts

  • Python | The Print and Divide Puzzle October 30, 2020
  • Python | Count consecutive 1’s from a list of 0’s and 1’s October 30, 2020
  • Python | How to convert a number into a list of its digits October 26, 2020
  • Python | Validate an IP Address-IPV6(Internet Protocol version 6) October 26, 2020
  • Python | Print the first non-recurring element in a list October 26, 2020
  • Python | Print the most recurring element in a list October 26, 2020
  • Python | Find the cumulative sum of elements in a list October 26, 2020
  • Python | Check a character is present in a string or not October 26, 2020
  • Python | Check whether a string is palindrome or not October 26, 2020
  • Python | Find the missing number in the array of Ints October 26, 2020
  • Python | How would you delete duplicates in a list October 26, 2020
  • Python | Check whether an array is Monotonic or not October 26, 2020
  • Python | Check whether a number is prime or not October 26, 2020
  • Python | Print list of prime numbers up to a number October 26, 2020
  • Python | Print elements from odd positions in a list October 26, 2020
  • Python | Print positions of a string present in another string October 26, 2020
  • Python | How to sort an array in ascending order October 26, 2020
  • Python | How to reverse an array October 26, 2020
  • Python | Find un-common words from two strings October 26, 2020
  • Python | How to convert a string to a list October 26, 2020
  • Python | Find unique words from a string October 26, 2020
  • Python | Calculate average word length from a string October 26, 2020
  • Python | Find common words from two strings October 26, 2020
  • Python | Find the number of times a substring present in a string October 26, 2020
  • Python | Find maximum value from a list October 26, 2020
  • Python | How to find GCF of two numbers October 26, 2020
  • Python | How to find LCM of two numbers October 26, 2020
  • Python | How to convert a list to a string October 26, 2020
  • Python | Replace NONE by its previous NON None value October 26, 2020
  • Microsoft SQL Server 2019 | Features added to SQL Server on Linux September 26, 2018

Create a website or blog at WordPress.com

  • Follow Following
    • Improving my SQL BI Skills
    • Join 231 other followers
    • Already have a WordPress.com account? Log in now.
    • Improving my SQL BI Skills
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar