Help with drawing conclusions from excel data and SQL basics - basic task

Employer
no avatar
lokotoko
Description

1. using a dataset on cab travel - try to determine as many facts about it as possible: check what the dataset contains

the dataset, evaluate the quality of this data, and draw information and conclusions from this data.

2. using access to the dataset in Google Bigquery on airplane flights

conduct an analogous analysis as in task 1, but this time, in addition to the results and

conclusions, include your SQL queries in the solution.

https://bigquery.cloud.google.com/table/bigquery-samples:airline_ontime_data.flights

3. using SQL, add an additional column to this table with the previous qty number for the

previous order of a given customer.

4. what is the problem in the following SQL query?

SELECT customer_id,

AVG(revenue)

FROM x

WHERE AVG(revenue) > 75

GROUP BY customer_id

Simple and quick tasks for the analyst. time - until the end of Saturday (02.07)

Published
on 2022-07-01
The job in figures:
1 excel file, 1 sql file

Offers sent (0)

No offers
No offers

No freelancer has sent an offer yet. Yours will be the first!

Budget
60.00 PLN
Copyright
-
Expires in
30 days