SQL-Query-Series

KO | EN

gitlite — search

#python #hacktoberfest #llm #go #deep-learning #macos #java #awesome #cli #kubernetes #awesome-list #security #mcp #open-source

SQL-Query-Series

(★ 73)

This Repo Contains Awesome SQL Queries for Data Enthusiasts

SQL-Query-Series Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# SQL-Solutions
 This repository contain all the solutions of SQL challenges With Code Snippets.
 
 
 
 |Daywise| Blog |
|-|-|
|Day1 (Data Science Skills) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_sql-60daysofcodechallenge-60daysofsql-activity-7011382301850775552-ele8?utm_source=share&utm_medium=member_desktop)
|Day2 (Page with No Likes) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7011696789795827712-OZe4?utm_source=share&utm_medium=member_desktop)
|Day3 (Tesla Unfinished Part) |[Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7012054438768963584-UZzN?utm_source=share&utm_medium=member_desktop)
|Day4 (Laptop Vs Mobile Viewership) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7012425690746646528-1gpI?utm_source=share&utm_medium=member_desktop)
|Day5 (Duplicated Job Listing) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7012800180013936640-Q5CD?utm_source=share&utm_medium=member_desktop)
|Day6 (Average Post Hiatus ) |[Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7013144746709671936-iI4q?utm_source=share&utm_medium=member_desktop)
|Day7 (Teams Power Users )| [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7013503805258403842-D-Py?utm_source=share&utm_medium=member_desktop)
|Day8 (Cities with Complete Trade) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7013870147476074499-v5co?utm_source=share&utm_medium=member_desktop)
|Day9 (Average Stars ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7014184321053782016-5j-M?utm_source=share&utm_medium=member_desktop)
|Day10 (App Click Through Rate) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7015316830126772224-uHA4?utm_source=share&utm_medium=member_desktop)
|Day11 (Second Day Confirmation) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7015701361149276160-w5QL?utm_source=share&utm_medium=member_desktop)
|Day12 (JP Morgan Credit Card )| [Explanation Link](https://www.linkedin.com/posts/sachintukumar_creditcards-60daysofcodechallenge-60daysofsql-activity-7016058427185508352-wbXh?utm_source=share&utm_medium=member_desktop)
|Day13 (Pharmacy Analytics Part-1) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_pharmacy-query-60daysofcodechallenge-activity-7016405090823475200-axKf?utm_source=share&utm_medium=member_desktop)
|Day14 (Pharmacy Analytics Part-2) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7016787494641831937-18nm?utm_source=share&utm_medium=member_desktop)
|Day15 (Department Top Three Salaries) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7017133984249737216-7qjF?utm_source=share&utm_medium=member_desktop)
|Day16 (Customers Who Never Orders ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7017499093467869185-KGFS?utm_source=share&utm_medium=member_desktop) 
|Day17 (Olympics Gold Medal ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7017853815223652352-Dmuk?utm_source=share&utm_medium=member_desktop)
|Day18 (Business Holidays ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7018599839856795648-NhZ6?utm_source=share&utm_medium=member_desktop)
|Day19 (Duplicated Entry ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_github-sachinkumar1609sql-portfolio-project-activity-7019294771617640448-Rjjk?utm_source=share&utm_medium=member_desktop)
|Day20 (Pharmacy Analytics Part-3) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7020019772687794176-_jkO?utm_source=share&utm_medium=member_desktop)
|Day21 (Patient Support Analysis Part-1) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_sunday-query-60daysofcodechallenge-activity-7020268213498195968-SVYk?utm_source=share&utm_medium=member_desktop)
|Day22 (Patient Support Analysis Part-2) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_pharmacy-query-60daysofcodechallenge-activity-7021097410462388224-hmIp?utm_source=share&utm_medium=member_desktop)
|Day23 ( Zomato SQL Queries )  | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_sql-project-on-zomato-analytics-activity-7022917128999550976-UZQu?utm_source=share&utm_medium=member_desktop)
|Day24 ( Not Null ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7023660911110369280-sSrX?utm_source=share&utm_medium=member_desktop)
|Day25 ( Finding User Purchase ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7025828273435652096-72rt?utm_source=share&utm_medium=member_desktop)
|Day26 ( Employees Earning More Than Their Managers ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7026197438151438337-0mc1?utm_source=share&utm_medium=member_desktop)
|Day27 ( Customers Without Orders ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_60daysofcodechallenge-60daysofsql-30daysofsql-activity-7026554900746493952-Te_h?utm_source=share&utm_medium=member_desktop)
|Day28 ( Olympics Gold Medal ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_sql-queries-activity-7030180159366311936-6L-H?utm_source=share&utm_medium=member_desktop)
|Day29 ( FinTech Startup ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_sqlqueries-100daysofcodechallenge-dataanalytics-activity-7047109587413393409-7Far?utm_source=share&utm_medium=member_desktop)
|Day30 ( 3 Topping Pizza ) | [Explanation Link](https://www.linkedin.com/posts/sachintukumar_30daysofsql-data-datascience-activity-7050478324095041536-CKNl?utm_source=share&utm_medium=member_desktop)

![Fintech Startup Question](https://user-images.githubusercontent.com/103982094/228803165-415ff305-d8d7-49e2-ba93-1359bf69c74f.png)

![Customers Without Orders ( StrataScratch )](https://user-images.githubusercontent.com/103982094/216073122-8f0345bd-8885-43c5-ae92-ae7da43d00da.png)

![Employees Earning More ( LeetCode )](https://user-images.githubusercontent.com/103982094/215846522-4e2eefdd-bb68-484d-8701-1962870ce45c.png)

![Finding User Purchases ( Stratascratch)](https://user-images.githubusercontent.com/103982094/215505060-122fc84e-8ff3-448c-b7a1-9eecc59fc914.png)

![Not Null Value](https://user-images.githubusercontent.com/103982094/214335474-ff7a7c44-1258-4a0c-9b67-1c671814f684.png)

![1671718784261](https://user-images.githubusercontent.com/103982094/211244667-ba74fdf6-0eb7-41bf-98d0-d4b19b17fcb5.png)
 
 
 ![1671804055027](https://user-images.githubusercontent.com/103982094/211245472-44d7ae14-bf8a-4a77-8797-71d752e969bc.png)
 
 ![1671892568480](https://user-images.githubusercontent.com/103982094/211245731-f857fd36-9182-41bb-9838-d97c5c7f5cfc.png)
 
 ![1671981853631](https://user-images.githubusercontent.com/103982094/211246010-ea3cf036-1973-4a69-b2da-57ecc51737a3.png)
 
 ![1672064002709](https://user-images.githubusercontent.com/103982094/211246142-4e351f42-073e-44cc-92a5-4740513a9658.png)
 
 ![1672149610122](https://user-images.githubusercontent.com/103982094/211246300-c5ba8afc-af7f-4294-8e0c-e8b74e83a129.png)
 
8. ![1672236953671](https://user-images.githubusercontent.com/103982094/211246457-21e2ad05-b3b6-4973-880e-292435a7b68e.png)
9. 
10. ![1672311857494](https://user-images.githubusercontent.com/103982094/211246583-6276e42f-e821-4662-9e05-fd9dd453e1a8.png)
11. ![1672581869716](https://user-images.githubusercontent.com/103982094/211246820-6b570b7a-6994-45eb-882a-19c1827f30a0.png)
12. ![1672673549033](https://user-images.githubusercontent.com/103982094/211246988-8b14e934-a74c-4c17-ae03-780029fa8aa6.png)
13. ![1672758679540](https://user-images.githubusercontent.com/103982094/211247089-dbbb54ae-1b4a-42bd-9a84-ecb51e8e1011.png)
14. ![1672841331056](https://user-images.githubusercontent.com/103982094/211247190-45eb7af2-e3db-49dc-907f-e30993ad98d2.png)
15. ![1672932503514](https://user-images.githubusercontent.com/103982094/211247284-193531ef-1757-4155-a048-ec0b5cdfe0d4.png)
16. ![1673015112986](https://user-images.githubusercontent.com/103982094/211247544-478f35c3-4d27-4be7-bc2a-89e76cb8850a.png)
17. ![1673102161210](https://user-images.githubusercontent.com/103982094/211247853-1aa42151-0725-4ce6-8972-97c8512e5e5c.png)
18. ![Olympic Gold Medals Problem](https://user-images.githubusercontent.com/103982094/211247985-7d15da7b-820f-4615-810b-bd317f3acc13.png)
19. ![Pharmacy Analytics (Part 3)](https://user-images.githubusercontent.com/103982094/212479983-25b73f7c-e94c-4001-a07d-114a681efb8f.png)
20. ![Patient Support Analysis (Part 1)](https://user-images.githubusercontent.com/103982094/212526753-c569a12a-38e9-4301-8325-152fb13800b6.png)
21. ![Patient Support Analysis (Part 2)](https://user-images.githubusercontent.com/103982094/212908833-4e74ead0-feb2-4bbd-a0b9-70ce925d173f.png)

22. ![1671643805067](https://user-images.githubusercontent.com/103982094/211244158-c8a83e05-a83b-43e8-b94e-e7c1757fc838.png)

SQL-Query-Series

SQL-Query-Series Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

SQL-Query-Series

SQL-Query-Series Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README