Repository navigation

StrataScratch

Public

About

SQL Practice https://www.stratascratch.com/

database interview-preparation programming sql

40 stars

1 watching

Report repository

Name		Name	Last commit message	Last commit date
Acceptance Rate By Date.sql		Acceptance Rate By Date.sql
Average Salaries.sql		Average Salaries.sql
Classify each business as either a restaurant, cafe, taqueria, kitchen, garden, school, or other.sql		Classify each business as either a restaurant, cafe, taqueria, kitchen, garden, school, or other.sql
Count the number of inspections with violations that happened to 'Roxanne Cafe' in each year.sql		Count the number of inspections with violations that happened to 'Roxanne Cafe' in each year.sql
Count the number of movies that Abigail Breslin nominated for oscar.sql		Count the number of movies that Abigail Breslin nominated for oscar.sql
Count the number of user events performed by MacBookPro users.sql		Count the number of user events performed by MacBookPro users.sql
Counting Instances in Text.sql		Counting Instances in Text.sql
Customer Details.sql		Customer Details.sql
Customer Revenue In March.sql		Customer Revenue In March.sql
Employee and Manager Salaries.sql		Employee and Manager Salaries.sql
Find all posts which were reacted to with a heart.sql		Find all posts which were reacted to with a heart.sql
Find all wineries which produce wines by possessing aromas of plum, cherry, rose, or hazelnut.sql		Find all wineries which produce wines by possessing aromas of plum, cherry, rose, or hazelnut.sql
Find artists that have been on Spotify the most number of times.sql		Find artists that have been on Spotify the most number of times.sql
Find hotels with the highest number of reviews.sql		Find hotels with the highest number of reviews.sql
Find libraries who haven't provided the email address in 2016 but their notice preference definition is set to email.sql		Find libraries who haven't provided the email address in 2016 but their notice preference definition is set to email.sql
Find matching hosts and guests in a way that they are both of the same gender and nationality.sql		Find matching hosts and guests in a way that they are both of the same gender and nationality.sql
Find songs that have placed in the top position the most number of times.sql		Find songs that have placed in the top position the most number of times.sql
Find the activity date of churros when they had less than 95 points.sql		Find the activity date of churros when they had less than 95 points.sql
Find the average popularity of the Hack per office location.sql		Find the average popularity of the Hack per office location.sql
Find the base pay for Police Captains.sql		Find the base pay for Police Captains.sql
Find the highest number of 'cool' votes a review received.sql		Find the highest number of 'cool' votes a review received.sql
Find the most profitable company in the financial sector of the entire world along with its continent.sql		Find the most profitable company in the financial sector of the entire world along with its continent.sql
Find the number of apartments per nationality that are owned by people under 30 years old.sql		Find the number of apartments per nationality that are owned by people under 30 years old.sql
Find the rate of processed tickets for each type.sql		Find the rate of processed tickets for each type.sql
Find the three most profitable companies.sql		Find the three most profitable companies.sql
Find the top 10 ranked songs in 2010.sql		Find the top 10 ranked songs in 2010.sql
Find the top 5 businesses with most reviews.sql		Find the top 5 businesses with most reviews.sql
Finding Updated Records.sql		Finding Updated Records.sql
Highest Cost Orders.sql		Highest Cost Orders.sql
Highest Energy Consumption.sql		Highest Energy Consumption.sql
Highest Salary In Department.sql		Highest Salary In Department.sql
Highest Target Under Manager.sql		Highest Target Under Manager.sql
Host Popularity Rental Prices.sql		Host Popularity Rental Prices.sql
Income By Title and Gender.sql		Income By Title and Gender.sql
Largest Olympics.sql		Largest Olympics.sql
Lowest Priced Orders.sql		Lowest Priced Orders.sql
Lyft Driver Wages.sql		Lyft Driver Wages.sql
Marketing Campaign Success.sql		Marketing Campaign Success.sql
Most Orders By Customer.sql		Most Orders By Customer.sql
No Order Customers.sql		No Order Customers.sql
Number Of Bathrooms And Bedrooms.sql		Number Of Bathrooms And Bedrooms.sql
Number of Streets Per Zip Code.sql		Number of Streets Per Zip Code.sql
Order Details.sql		Order Details.sql
Out of Order Bikes.sql		Out of Order Bikes.sql
Popularity Percentage.sql		Popularity Percentage.sql
Premium vs Freemium.sql		Premium vs Freemium.sql
README.md		README.md
Ranking Most Active Guests.sql		Ranking Most Active Guests.sql
Salaries Differences.sql		Salaries Differences.sql
Top 5 States With 5 Star Businesses.sql		Top 5 States With 5 Star Businesses.sql
Top Cool Votes.sql		Top Cool Votes.sql
Top Search Results.sql		Top Search Results.sql
Valuable Departments.sql		Valuable Departments.sql

Repository files navigation

StrataScratch

About

SQL Practice https://www.stratascratch.com/

database interview-preparation programming sql

40 stars

1 watching

Report repository

Releases

Packages

Contributors