It looks like the BigQuery Geo Viz repository is inactive. If I’d like to contribute a feature, is this still the correct place to do so?

I have a BigQuery issue I am trying to learn/ work around. I need to get the elapsed time in seconds between a min observation and a max observation.

I have the Google Big Query Project In which I am required to delete duplications from the a column. What is the efficient way to do it ? I am new in Google Big Query ?

`WITH RECURSIVE EducationClassification AS (
SELECT
code,
name_en,
description_en,
education_classification_code,
historic_ind,
source,
effective_date,
expiration_date,
CAST(level AS INT64) as level,
parent,
code AS level_0_code,
name_en AS level_0_name,
NULL AS level_1_code,
NULL AS level_1_name,
NULL AS level_2_code,
NULL AS level_2_name,
NULL AS level_3_code,
NULL AS level_3_name,
CASE
WHEN CAST(level AS INT64) = 0 THEN ‘Root’
ELSE ‘Leaf’
END AS node_type
FROM
input_table
WHERE
CAST(level AS INT64) = 0

I have a column of ID’s and a column of strings. In reality these strings are ordinal however, so when grouping by the ID I would like some method of selecting the maximum of the custom order.

i don’t understand what’s my mistake here.this is the image of my query pls refer this and help me where am I getting stuck

I created two views

I am a first time user of BigQuery to earn my Google Data Analytics certificate. I am trying to follow along on a course exercise but I cannot get past the initial steps.

SELECT ride_id,
rideable_type,
started_at,
ended_at,
start_station_name,
start_station_id,
end_station_name,
start_lat,
start_lng,
end_lat,
end_lng,
member_casual,
FROM (
SELECT ride_id ,
rideable_type,
started_at,
ended_at,
start_station_name,
start_station_id,
end_station_name,
start_lat,
start_lng,
end_lat,
end_lng,
member_casual,
ROW_NUMBER() OVER (PARTITION BY ride_id ORDER BY ride_id) AS row_num
FROM cyclistic-429604.yearly_csv.nu_null
)

I have a table in BigQuery I’m trying to create in BigQuery that looks as such: