Skip to content

suman6565/StrataScratch

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

53 Commits
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

image

About

SQL Practice

Resources

Readme
Activity

Stars

1 star

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published