Job 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)