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

Easy - Google

Nr
Company
Difficulty
ID Number
Title
Link
Table

1

Google

Easy

ID 2100

Salary by Education

google_salaries

2

Google

Easy

ID 2163

Sorting Movies By Duration Time

movie_catalogue

3

Google

Easy

ID 9598

Find non-HS SAT scores

sat_scores

4

Google

Easy

ID 9649

Count the number of accounts used for logins in 2016

product_logins

5

Google

Easy

ID 9660

Count the number of students lectured by each teacher

sat_scores

6

Google

Easy

ID 9667

Count users that speak English, German, French or Spanish

playbook_users

7

Google

Easy

ID 9669

Count the number of speakers per each language

playbook_users

8

Google

Easy

ID 9685

Companies With Chinese Speakers

playbook_users

9

Google

Easy

ID 9805

Find drafts which contains the word 'optimism'

google_file_store

10

Google

Easy

ID 9806

Find all records with words that start with the letter 'g'

google_word_lists

11

Google

Easy

ID 9807

Find all companies with more than 10 employees

google_adwords_earnings

12

Google

Easy

ID 9808

Find business types present in the dataset

google_adwords_earnings

13

Google

Easy

ID 10164

Total AdWords Earnings

google_adwords_earnings

14

Google

Easy

ID 9932

Women In The Olympics Before World War 2

olympics_athletes_events

15

Google

Easy

ID 2072

Active Users Per Platform

user_sessions

16

Google

Easy

ID 2091

Latest Login Date

players_logins

17

Google

Easy

ID 9861

Total Employees in Each Department

worker

18

Google

Easy

ID 9862

Last Record Without LIMIT or ORDER BY

worker

19

Google

Easy

ID 9863

First Record Without LIMIT or ORDER BY

worker

Last updated 1 year ago

Was this helpful?

1

https://platform.stratascratch.com/coding/2100-salary-by-education?code_type=1
https://platform.stratascratch.com/coding/2163-sorting-movies-by-duration-time?code_type=1
https://platform.stratascratch.com/coding/9598-find-non-hs-sat-scores?code_type=1
https://platform.stratascratch.com/coding/9649-count-the-number-of-accounts-used-for-logins-in-2016?code_type=1
https://platform.stratascratch.com/coding/9660-count-the-number-of-students-lectured-by-each-teacher?code_type=1
https://platform.stratascratch.com/coding/9667-count-users-that-speak-english-german-french-or-spanish?code_type=1
https://platform.stratascratch.com/coding/9669-count-the-number-of-speakers-per-each-language?code_type=1
https://platform.stratascratch.com/coding/9685-companies-with-chinese-speakers?code_type=1
https://platform.stratascratch.com/coding/9805-find-drafts-which-contains-the-word-optimism?code_type=1
https://platform.stratascratch.com/coding/9806-find-all-records-with-words-that-start-with-the-letter-g?code_type=1
https://platform.stratascratch.com/coding/9807-find-all-companies-with-more-than-10-employees?code_type=1
https://platform.stratascratch.com/coding/9808-find-business-types-present-in-the-dataset?code_type=1
https://platform.stratascratch.com/coding/10164-total-adwords-earnings?code_type=1
https://platform.stratascratch.com/coding/9932-women-in-the-olympics-before-world-war-2?code_type=1
https://platform.stratascratch.com/coding/2072-active-users-per-platform?code_type=1
https://platform.stratascratch.com/coding/2091-latest-login-date?code_type=1
https://platform.stratascratch.com/coding/9861-find-the-number-of-employees-in-each-department?code_type=1
https://platform.stratascratch.com/coding/9862-find-the-last-record-of-the-dataset-without-using-limit-or-order-by?code_type=1
https://platform.stratascratch.com/coding/9863-find-the-first-record-of-the-dataset-without-using-limit-or-order-by?code_type=1