Data Science Hub
  • Data Science Hub
  • STATISTICS
    • Introduction
    • Fundamentals
      • Data Types
      • Central Tendency, Asymmetry, and Variability
      • Sampling
      • Confidence Interval
      • Hypothesis Testing
    • Distributions
      • Exponential Distribution
    • A/B Testing
      • Sample Size Calculation
      • Multiple Testing
  • Database
    • Database Fundamentals
    • Database Management Systems
    • Data Warehouse vs Data Lake
  • SQL
    • SQL Basics
      • Creating and Modifying Tables/Views
      • Data Types
      • Joins
    • SQL Rules
    • SQL Aggregate Functions
    • SQL Window Functions
    • SQL Data Manipulation
      • String Operations
      • Date/Time Operations
    • SQL Descriptive Stats
    • SQL Tips
    • SQL Performance Tuning
    • SQL Customization
    • SQL Practice
      • Designing Databases
        • Spotify Database Design
      • Most Commonly Asked
      • Mixed Queries
      • Popular Websites For SQL Practice
        • SQLZoo
          • World - BBC Tables
            • SUM and COUNT Tutorial
            • SELECT within SELECT Tutorial
            • SELECT from WORLD Tutorial
            • Select Quiz
            • BBC QUIZ
            • Nested SELECT Quiz
            • SUM and COUNT Quiz
          • Nobel Table
            • SELECT from Nobel Tutorial
            • Nobel Quiz
          • Soccer / Football Tables
            • JOIN Tutorial
            • JOIN Quiz
          • Movie / Actor / Casting Tables
            • More JOIN Operations Tutorial
            • JOIN Quiz 2
          • Teacher - Dept Tables
            • Using Null Quiz
          • Edinburgh Buses Table
            • Self join Quiz
        • HackerRank
          • SQL (Basic)
            • Select All
            • Select By ID
            • Japanese Cities' Attributes
            • Revising the Select Query I
            • Revising the Select Query II
            • Revising Aggregations - The Count Function
            • Revising Aggregations - The Sum Function
            • Revising Aggregations - Averages
            • Average Population
            • Japan Population
            • Population Density Difference
            • Population Census
            • African Cities
            • Average Population of Each Continent
            • Weather Observation Station 1
            • Weather Observation Station 2
            • Weather Observation Station 3
            • Weather Observation Station 4
            • Weather Observation Station 6
            • Weather Observation Station 7
            • Weather Observation Station 8
            • Weather Observation Station 9
            • Weather Observation Station 10
            • Weather Observation Station 11
            • Weather Observation Station 12
            • Weather Observation Station 13
            • Weather Observation Station 14
            • Weather Observation Station 15
            • Weather Observation Station 16
            • Weather Observation Station 17
            • Weather Observation Station 18
            • Weather Observation Station 19
            • Higher Than 75 Marks
            • Employee Names
            • Employee Salaries
            • The Blunder
            • Top Earners
            • Type of Triangle
            • The PADS
          • SQL (Intermediate)
            • Weather Observation Station 5
            • Weather Observation Station 20
            • New Companies
            • The Report
            • Top Competitors
            • Ollivander's Inventory
            • Challenges
            • Contest Leaderboard
            • SQL Project Planning
            • Placements
            • Symmetric Pairs
            • Binary Tree Nodes
            • Interviews
            • Occupations
          • SQL (Advanced)
            • Draw The Triangle 1
            • Draw The Triangle 2
            • Print Prime Numbers
            • 15 Days of Learning SQL
          • TABLES
            • City - Country
            • Station
            • Hackers - Submissions
            • Students
            • Employee - Employees
            • Occupations
            • Triangles
        • StrataScratch
          • Netflix
            • Oscar Nominees Table
            • Nominee Filmography Table
            • Nominee Information Table
          • Audible
            • Easy - Audible
          • Spotify
            • Worldwide Daily Song Ranking Table
            • Billboard Top 100 Year End Table
            • Daily Rankings 2017 US
          • Google
            • Easy - Google
            • Medium - Google
            • Hard - Google
        • LeetCode
          • Easy
  • Python
    • Basics
      • Variables and DataTypes
        • Lists
        • Dictionaries
      • Control Flow
      • Functions
    • Object Oriented Programming
      • Restaurant Modeler
    • Pythonic Resources
    • Projects
  • Machine Learning
    • Fundamentals
      • Supervised Learning
        • Classification Algorithms
          • k-Nearest Neighbors
            • kNN Parameters & Attributes
          • Logistic Regression
        • Classification Report
      • UnSupervised Learning
        • Clustering
          • Evaluation
      • Preprocessing
        • Scalers: Standard vs MinMax
        • Feature Selection vs Dimensionality Reduction
        • Encoding
    • Frameworks
    • Machine Learning in Advertising
    • Natural Language Processing
      • Stopwords
      • Name Entity Recognition (NER)
      • Sentiment Analysis
        • Agoda Reviews - Part I - Scraping Reviews, Detecting Languages, and Preprocessing
        • Agoda Reviews - Part II - Sentiment Analysis and WordClouds
    • Recommendation Systems
      • Spotify Recommender System - Artists
  • Geospatial Analysis
    • Geospatial Analysis Basics
    • GSA at Work
      • Web Scraping and Mapping
  • GIT
    • GIT Essentials
    • Connecting to GitHub
  • FAQ
    • Statistics
  • Cloud Computing
    • Introduction to Cloud Computing
    • Google Cloud Platform
  • Docker
    • What is Docker?
Powered by GitBook
On this page

Was this helpful?

  1. SQL
  2. SQL Practice
  3. Popular Websites For SQL Practice
  4. StrataScratch
  5. Google

Medium - Google

Nr
Company
Difficulty
ID Number
Title
Link
Table

1

Google

Medium

ID 2099

Election Results

voting_results

2

Google

Medium

ID 2104

User with Most Approved Flags

user_flags, flag_review

3

Google

Medium

ID 2106

Rows With Missing Values

user_flags

4

Google

Medium

ID 9609

Find Nexus5 control group users in Italy who don't speak Italian

playbook_experiments, playbook_users

5

Google

Medium

ID 9668

English, German, French, Spanish Speakers

playbook_users

6

Google

Medium

ID 9810

Find all users that have more than 3 friends

google_friends_network

7

Google

Medium

ID 9811

Find the minimal adwords earnings for each business type

google_adwords_earnings

8

Google

Medium

ID 9812

Count the number of words per row in both words lists

google_word_lists

9

Google

Medium

ID 9813

Make the friends network symmetric

google_friends_network

10

Google

Medium

ID 9817

Find the number of times each word appears in drafts

google_file_store

11

Google

Medium

ID 9882

Find how the survivors are distributed by the gender and passenger classes

titanic

12

Google

Medium

ID 9889

Find how many logins Spanish speakers made by country

playbook_events, playbook_users

13

Google

Medium

ID 10068

User Email Labels

google_gmail_emails, google_gmail_labels

14

Google

Medium

ID 10070

DeepMind employment competition

google_competition_participants, google_competition_scores

15

Google

Medium

ID 10086

Email Details Based On Sends

google_gmail_emails

16

Google

Medium

ID 10120

Number Of Custom Email Labels

google_gmail_emails, google_gmail_labels

17

Google

Medium

ID 10351

Activity Rank

google_gmail_emails

18

Google

Medium

ID 9849

Find the duplicate records in the dataset

title

19

Google

Medium

ID 10089

Find the number of customers without an order

orders, customers

20

Google

Medium

ID 10090

Find the percentage of shipable orders

orders, customers

21

Google

Medium

ID 9874

Find the top ten hotels with the highest ratings

hotel_reviews

22

Google

Medium

ID 9875

Find the 10 lowest rated hotels

hotel_reviews

23

Google

Medium

ID 9878

Countries With Most Negative Reviews

hotel_reviews

Last updated 1 year ago

Was this helpful?

1

1

https://platform.stratascratch.com/coding/2099-election-results?code_type=1
https://platform.stratascratch.com/coding/2104-user-with-most-approved-flags?code_type=1
https://platform.stratascratch.com/coding/2106-rows-with-missing-values?code_type=1
https://platform.stratascratch.com/coding/9609-find-nexus5-control-group-users-in-italy-who-dont-speak-italian?code_type=1
https://platform.stratascratch.com/coding/9668-english-german-french-spanish-speakers?code_type=1
https://platform.stratascratch.com/coding/9810-find-all-uses-that-have-more-than-3-friends?code_type=1
https://platform.stratascratch.com/coding/9811-find-the-minimal-adwords-earnings-for-each-business-type?code_type=1
https://platform.stratascratch.com/coding/9812-count-the-number-of-words-per-row-in-both-words-lists?code_type=1
https://platform.stratascratch.com/coding/9813-make-the-friends-network-symmetric?code_type=1
https://platform.stratascratch.com/coding/9817-find-the-number-of-times-each-word-appears-in-drafts?code_type=1
https://platform.stratascratch.com/coding/9882-find-how-the-survivors-are-distributed-by-the-gender-and-passenger-classes?code_type=1
https://platform.stratascratch.com/coding/9889-find-how-many-logins-spanish-speakers-made-by-country?code_type=1
https://platform.stratascratch.com/coding/10068-user-email-labels?code_type=1
https://platform.stratascratch.com/coding/10070-deepmind-employment-competition?code_type=1
https://platform.stratascratch.com/coding/10086-email-details-based-on-sends?code_type=1
https://platform.stratascratch.com/coding/10120-number-of-custom-email-labels?code_type=1
https://platform.stratascratch.com/coding/10351-activity-rank?code_type=1
https://platform.stratascratch.com/coding/9849-find-the-duplicate-records-in-the-dataset?code_type=1
https://platform.stratascratch.com/coding/10089-find-the-number-of-customers-without-an-order?code_type=1
https://platform.stratascratch.com/coding/10090-find-the-percentage-of-shipable-orders?code_type=1
https://platform.stratascratch.com/coding/9874-find-the-top-ten-hotels-with-the-highest-ratings?code_type=1
https://platform.stratascratch.com/coding/9875-find-the-ten-hotels-with-the-lowest-ratings?code_type=1
https://platform.stratascratch.com/coding/9878-countries-with-most-negative-reviews?code_type=1