Skip to content

Zahidsqldba07/HackerRank-LeetCode-StrataScratch-SQL

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
DataLemur Data Science Skills.sql
DataLemur Data Science Skills.sql
 
 
DataLemur Even and Odd Measurements.sql
DataLemur Even and Odd Measurements.sql
 
 
DataLemur Frequently Purchased Pairs.sql
DataLemur Frequently Purchased Pairs.sql
 
 
DataLemur Invalid Search Results.sql
DataLemur Invalid Search Results.sql
 
 
DataLemur Monthly Merchant Balance.sql
DataLemur Monthly Merchant Balance.sql
 
 
DataLemur Users Third Transaction.sql
DataLemur Users Third Transaction.sql
 
 
HackerRank 15 Days of Learning SQL.sql
HackerRank 15 Days of Learning SQL.sql
 
 
HackerRank Activity Rank.sql
HackerRank Activity Rank.sql
 
 
HackerRank Contest Leaderboard.sql
HackerRank Contest Leaderboard.sql
 
 
HackerRank Occupations.sql
HackerRank Occupations.sql
 
 
HackerRank Placements.sql
HackerRank Placements.sql
 
 
HackerRank SQL Project Planning.sql
HackerRank SQL Project Planning.sql
 
 
HackerRank The PADS.sql
HackerRank The PADS.sql
 
 
LeetCode 1141 User Activity for the Past 30 Days I.sql
LeetCode 1141 User Activity for the Past 30 Days I.sql
 
 
LeetCode 1393 Capital Gain Loss.sql
LeetCode 1393 Capital Gain Loss.sql
 
 
LeetCode 1407 Top Travellers.sql
LeetCode 1407 Top Travellers.sql
 
 
LeetCode 1484 Group Sold Products By The Date.sql
LeetCode 1484 Group Sold Products By The Date.sql
 
 
LeetCode 177 Nth Highest Salary.sql
LeetCode 177 Nth Highest Salary.sql
 
 
LeetCode 1795 Rearrange Products Table.sql
LeetCode 1795 Rearrange Products Table.sql
 
 
LeetCode 180 Consecutive Numbers.sql
LeetCode 180 Consecutive Numbers.sql
 
 
LeetCode 184 Department Highest Salary.sql
LeetCode 184 Department Highest Salary.sql
 
 
LeetCode 185 Department Top Three Salaries.sql
LeetCode 185 Department Top Three Salaries.sql
 
 
LeetCode 196 Delete Duplicate Emails.sql
LeetCode 196 Delete Duplicate Emails.sql
 
 
LeetCode 197 Rising Temperature.sql
LeetCode 197 Rising Temperature.sql
 
 
LeetCode 607 Sales Person.sql
LeetCode 607 Sales Person.sql
 
 
LeetCode 608 Tree Node.sql
LeetCode 608 Tree Node.sql
 
 
Procedural Code.sql
Procedural Code.sql
 
 
README.md
README.md
 
 
StrataScratch 514 Marketing Campaign Success Advanced.sql
StrataScratch 514 Marketing Campaign Success Advanced.sql
 
 
StrataScratch 10026 Find all wineries.sql
StrataScratch 10026 Find all wineries.sql
 
 
StrataScratch 10046 Top 5 States With 5 Star Businesses.sql
StrataScratch 10046 Top 5 States With 5 Star Businesses.sql
 
 
StrataScratch 10048 Top Businesses With Most Reviews.sql
StrataScratch 10048 Top Businesses With Most Reviews.sql
 
 
StrataScratch 10049 Reviews of Categories.sql
StrataScratch 10049 Reviews of Categories.sql
 
 
StrataScratch 10060 Top Cool Votes.sql
StrataScratch 10060 Top Cool Votes.sql
 
 
StrataScratch 10061 Popularity of Hack.sql
StrataScratch 10061 Popularity of Hack.sql
 
 
StrataScratch 10064 Highest Energy Consumption.sql
StrataScratch 10064 Highest Energy Consumption.sql
 
 
StrataScratch 10077 Income By Title and Gender.sql
StrataScratch 10077 Income By Title and Gender.sql
 
 
StrataScratch 10078 Find matching hosts and guests in a way that they are both of the same gender and nationality.sql
StrataScratch 10078 Find matching hosts and guests in a way that they are both of the same gender and nationality.sql
 
 
StrataScratch 10156 Number Of Units Per Nationality.sql
StrataScratch 10156 Number Of Units Per Nationality.sql
 
 
StrataScratch 10159 Ranking Most Active Guests.sql
StrataScratch 10159 Ranking Most Active Guests.sql
 
 
StrataScratch 10284 Popularity Percentage.sql
StrataScratch 10284 Popularity Percentage.sql
 
 
StrataScratch 10285 Acceptance Rate By Date.sql
StrataScratch 10285 Acceptance Rate By Date.sql
 
 
StrataScratch 10299 Finding Updated Records.sql
StrataScratch 10299 Finding Updated Records.sql
 
 
StrataScratch 10300 Premium vs Freemium.sql
StrataScratch 10300 Premium vs Freemium.sql
 
 
StrataScratch 10319 Monthly Percentage Difference.sql
StrataScratch 10319 Monthly Percentage Difference.sql
 
 
StrataScratch 10322 Finding User Purchases.sql
StrataScratch 10322 Finding User Purchases.sql
 
 
StrataScratch 10352 Users By Average Session Time.sql
StrataScratch 10352 Users By Average Session Time.sql
 
 
StrataScratch 10354 Most Profitable Companiess.sql
StrataScratch 10354 Most Profitable Companiess.sql
 
 
StrataScratch 2059 Player with Longest Streak.sql
StrataScratch 2059 Player with Longest Streak.sql
 
 
StrataScratch 9632 Host Popularity Rental Prices.sql
StrataScratch 9632 Host Popularity Rental Prices.sql
 
 
StrataScratch 9650 Find the top 10 ranked songs in 2010.sql
StrataScratch 9650 Find the top 10 ranked songs in 2010.sql
 
 
StrataScratch 9726 Classify Business Type.sql
StrataScratch 9726 Classify Business Type.sql
 
 
StrataScratch 9728 Number of violations.sql
StrataScratch 9728 Number of violations.sql
 
 
StrataScratch 9781 Find the rate of processed tickets for each type.sql
StrataScratch 9781 Find the rate of processed tickets for each type.sql
 
 
StrataScratch 9782 Customer Revenue In March.sql
StrataScratch 9782 Customer Revenue In March.sql
 
 
StrataScratch 9814 Counting Instances in Text.sql
StrataScratch 9814 Counting Instances in Text.sql
 
 
StrataScratch 9894 Employee and Manager Salaries.sql
StrataScratch 9894 Employee and Manager Salaries.sql
 
 
StrataScratch 9905 Highest Target Under Manager.sql
StrataScratch 9905 Highest Target Under Manager.sql
 
 
StrataScratch 9915 Highest Cost Orders.sql
StrataScratch 9915 Highest Cost Orders.sql
 
 
StrataScratch 9942 Largest Olympics.sql
StrataScratch 9942 Largest Olympics.sql
 
 
Window rolling average.sql
Window rolling average.sql
 
 

Repository files navigation

DataLemur-HackerRank-LeetCode-StrataScratch-SQL

Answers to various SQL questions on DataLemur.com, HackerRank.com, LeetCode.com and StrataScratch.com.

These sites are excellent sites to learn and practice SQL.

I created a cloud PostgreSQL database in Azure so I could experiment and practice using postgres SQL extensions to answer the questions. Sometimes I would create my own tables and data to practice some concept beyond what the questions were asking.

About

Answers to various SQL questions on DataLemur.com, HackerRank.com, LeetCode.com and StrataScratch.com.

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • PLpgSQL 100.0%