DataLemur-HackerRank-LeetCode-StrataScratch-SQL

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

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.

DataQuest solutions are for SQLite stores.db

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

DataLemur-HackerRank-LeetCode-StrataScratch-SQL

About

Releases

Packages

Languages

Name		Name	Last commit message	Last commit date
Latest commit History 11 Commits
Coalesce discounted price.sql		Coalesce discounted price.sql
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
DataQuest Question1.sql		DataQuest Question1.sql
DataQuest Question2.sql		DataQuest Question2.sql
DataQuest Question3-2.sql		DataQuest Question3-2.sql
DataQuest Question3-3.sql		DataQuest Question3-3.sql
DataQuest Question3.sql		DataQuest Question3.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

MrLRTripp/HackerRank-LeetCode-StrataScratch-SQL

Folders and files

Latest commit

History

Repository files navigation

DataLemur-HackerRank-LeetCode-StrataScratch-SQL

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages