Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me to write 2 queries in Big Query(SQL) on Google Cloud's Hacker News Data( https://cloud.google.com/bigquery/public-data/hacker-news ) . Schema of the data: id INTEGER
Please help me to write 2 queries in Big Query(SQL) on Google Cloud's Hacker News Data( https://cloud.google.com/bigquery/public-data/hacker-news ) .
Schema of the data:
id | INTEGER | Unique story ID |
by | STRING | Username of submitter |
score | INTEGER | Story score |
time | INTEGER | Unix time |
time_ts | TIMESTAMP | Human readable time in UTC (format: YYYY-MM-DD hh:mm:ss) |
title | STRING | Story title |
url | STRING | Story url |
text | STRING | Story text |
deleted | BOOLEAN | Is deleted? |
dead | BOOLEAN | Is dead? |
descendants | INTEGER | Number of story descendants |
author | STRING | Username of author |
a. On average which URL produced the best story in 2010?
b. List how many stories were posted by each author on nytimes.com and wired.com.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started