Erica Bertan ericabertan

## first_value.sql
SELECT
  artists,
  name,
  danceability,
  FIRST_VALUE (name) OVER (PARTITION BY artists ORDER BY danceability) AS first_danceability
FROM `spotify-sample1`.spotify
ORDER BY artists, danceability

## first_last_value_syntax.sql
FIRST_VALUE | LAST_VALUE
( expression [ IGNORE NULLS | RESPECT NULLS ] ) OVER
(
[ PARTITION BY expr_list ]
[ ORDER BY order_list frame_clause ]
)

## History|-109e5c02|entries.json
{"version":1,"resource":"file:///Users/ericabertan/dev/hoppers/client-web/generators/plopfile.js","entries":[{"id":"GBY3.js","timestamp":1697229058356},{"id":"Ha5u.js","timestamp":1699743458970},{"id":"V6rc.js","source":"undoRedo.source","timestamp":1699743468118}]}

## coalesce_nvl_example1.sql
SELECT COALESCE(NULL, NULL, 1, NULL);

## row_number_example.sql
SELECT
	artists,
	name,
	danceability,
	ROW_NUMBER() OVER (PARTITION BY artists ORDER BY danceability DESC) AS number
FROM spotify
GROUP BY artists, name, danceability

## row_number_syntax.sql
ROW_NUMBER() OVER (
    [PARTITION BY expr1, expr2,...]
    ORDER BY expr1 [ASC | DESC], expr2,...
)

## greatest_least_third_example.sql
SELECT
  book_name,
  author,
  GREATEST(MAX(updated_at), MAX(created_at), MAX(dropout_at)) AS last_update
FROM "public"."products"
GROUP BY
  book_name,
  author

## greatest_least_first_example.sql
SELECT GREATEST(1, 5, 3, 4, -1), LEAST(1, 5, 3, 4, -1)

## greatest_least_second_example.sql
SELECT
  id,
  name,
  danceability,
  energy,
  GREATEST(danceability, energy) AS greatest,
  LEAST(danceability, energy) AS least
FROM "public"."featuresdf"

## 3_load_theme.sh
source ~/.zshrc
	SELECT
	artists,
	name,
	danceability,
	FIRST_VALUE (name) OVER (PARTITION BY artists ORDER BY danceability) AS first_danceability
	FROM `spotify-sample1`.spotify
	ORDER BY artists, danceability
	FIRST_VALUE \| LAST_VALUE
	( expression [ IGNORE NULLS \| RESPECT NULLS ] ) OVER
	(
	[ PARTITION BY expr_list ]
	[ ORDER BY order_list frame_clause ]
	)
	ROW_NUMBER() OVER (
	[PARTITION BY expr1, expr2,...]
	ORDER BY expr1 [ASC \| DESC], expr2,...
	)
	SELECT
	book_name,
	author,
	GREATEST(MAX(updated_at), MAX(created_at), MAX(dropout_at)) AS last_update
	FROM "public"."products"
	GROUP BY
	book_name,
	author