Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Please help me to write 1 queries in Big Query(SQL) on Google Cloud's Hacker News Data( https://cloud.google.com/bigquery/public-data/hacker-news ) On average which URL produced the best story in...

Q:

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

Q:

i know its a long project but please answer it based on the format below 1-Introduction 2-Data Requirements and Conceptual Design 3-Database Construction and Population 4-Querying the Database...

Q:

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

Q:

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Q:

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

Q:

The assignment: 1. Download and install Postgres. 2. In pgAdmin 4, on the left, explode the Servers to choose one, after which you should see the Databases item. Right-click on that item to create a...

Q:

urgent help needed for Java Code: 20-1. Write a program that will create a yankees table for a baseball part a Access database file. It will have fields for the name of the player, the position of...

Q:

Please help answer 16 and 17 or 18 and 20 if you can. This is all the information I was given below. As per the instructions you cannot use JOIN statements or subqueries. Here are the other questions...

Q:

im using MY SQL Workbench how can i set it up and also please help me write this thank Prepare for SQL Coding mysql > create database xyz; Query OK , 1 row affected ( 0 . 0 0 sec ) mysql > use xyz;...

Q:

In its 2008 annual report the Unilever Group, which published IFRS-based financial statements, reported the following in the inventory footnote (in million euros). "During 2008, 246 million euros...

Q:

Why would awareness of attitudes toward people with disabilities and the ADA be important to supervisor?

Q:

corporate fund started to share with a net acid value of $ 1 2 . 5 0 by a year and it's not acid value equal $ 1 2 . 1 0 the fund paid year and distributions of income in capital gains of $ 1 . 5 0...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

Write down a set of values that are important to you. Ask family members and friends to encourage you to live according to your values.

Q:

Describe key areas of your life that are important to you, and write down one or two goals in each major area. Select one or two goals and imagine the goal(s) being achieved to your full...

Q:

6. Does the organization that you work for hire and promote in such a way that employee diversity reflects the diversity of society?