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

Hard - Google

Last updated 1 year ago

Was this helpful?

Nr
Company
Difficulty
ID Number
Title
Link
Table

1

Google

Hard

ID 10303

Top Percentile Fraud

fraud_score

2

Google

Hard

ID 2073

Popular Posts

user_sessions, post_views

3

Google

Hard

ID 2103

Reviewed flags of top videos

user_flags, flag_review

4

Google

Hard

ID 2105

Videos Removed on Latest Date

user_flags, flag_review

5

Google

Hard

ID 9794

Words With Two Vowels

google_word_lists

6

Google

Hard

ID 9814

Counting Instances in Text

google_file_store

7

Google

Hard

ID 9815

Price Of A Handyman

google_adwords_earnings

8

Google

Hard

ID 9816

Find the list of intersections between both word lists

google_word_lists

9

Google

Hard

ID 9818

File Contents Shuffle

google_file_store

10

Google

Hard

ID 9821

Common Friends Friend

google_friends_network

11

Google

Hard

ID 9822

Find the average number of friends a user has

google_friends_network

12

Google

Hard

ID 9823

Common Letters

google_file_store, google_word_lists

13

Google

Hard

ID 9883

Find the oldest survivor per passenger class

titanic

14

Google

Hard

ID 10067

Google Fit User Tracking

google_fit_location

15

Google

Hard

ID 10069

Correlation Between E-mails And Activity Time

google_gmail_emails, google_fit_location

16

Google

Hard

ID 2059

Player with Longest Streak

players_results

https://platform.stratascratch.com/coding/10303-top-percentile-fraud?code_type=1
https://platform.stratascratch.com/coding/2073-popular-posts?code_type=1
https://platform.stratascratch.com/coding/2103-reviewed-flags-of-top-videos?code_type=1
https://platform.stratascratch.com/coding/2105-videos-removed-on-latest-date?code_type=1
https://platform.stratascratch.com/coding/9794-words-with-two-vowels?code_type=1
https://platform.stratascratch.com/coding/9814-counting-instances-in-text?code_type=1
https://platform.stratascratch.com/coding/9815-price-of-a-handyman?code_type=1
https://platform.stratascratch.com/coding/9816-find-the-list-of-intersections-between-both-word-lists?code_type=1
https://platform.stratascratch.com/coding/9818-file-contents-shuffle?code_type=1
https://platform.stratascratch.com/coding/9821-common-friends-friend?code_type=1
https://platform.stratascratch.com/coding/9822-find-the-average-number-of-friends-a-user-has?code_type=1
https://platform.stratascratch.com/coding/9823-common-letters?code_type=1
https://platform.stratascratch.com/coding/9883-find-the-oldest-survivor-per-passenger-class?code_type=1
https://platform.stratascratch.com/coding/10067-google-fit-user-tracking?code_type=1
https://platform.stratascratch.com/coding/10069-correlation-between-e-mails-and-activity-time?code_type=1
https://platform.stratascratch.com/coding/2059-player-with-longest-streak?code_type=1