create table clients (
  client_id int,
  client_fio varchar(255)
);

insert into clients values
(1, 'Иванов И.И.'),
(2, 'Петров П.П.'),
(3, 'Сидоров С.С.');

create table documents (
  client_id int,
  valid_from date,
  valid_to date,
  document_no varchar(9),
  income int
);

insert into documents values
(1, '2020-01-01', '2020-12-31', '111111-11', 100000),
(1, '2021-01-01', '2022-06-01', '111111-11', 120000),
(1, '2022-06-01', '9999-12-31', '333333-33', 120000),
(2, '2001-01-01', '2023-01-01', '555555-55', 50000);

SELECT c.client_id
FROM clients c
LEFT JOIN (
    SELECT DISTINCT client_id
    FROM documents
    WHERE valid_to = '9999-12-31'
) t1
  ON c.client_id = t1.client_id
WHERE t1.client_id IS NULL

SELECT client_id
FROM clients
WHERE client_id NOT IN (
    SELECT client_id
    FROM documents
    WHERE valid_to = '9999-12-31'
)

SELECT client_id
FROM clients c
WHERE NOT EXISTS (
    SELECT 1
    FROM documents d
    WHERE c.client_id = d.client_id
      AND valid_to = '9999-12-31'
    LIMIT 1
)

SELECT DISTINCT t1.*
FROM logs t1
  JOIN logs t2
    ON t1.id > t2.id AND t1.dt < t2.dt;

HashAggregate (cost=92291..92294) 
  Group Key: t1.id, t1.dt
  -> Nested Loop (cost=0..89454)
    Join Filter
    -> Seq Scan on logs t1 (cost=0..33)
    -> Materialize
      -> Seq Scan on logs t2

WITH diffs AS ( 
  SELECT 
    *,
    id - LAG(id) OVER(ORDER BY dt) prev_diff,
    id - LEAD(id) OVER(ORDER BY dt) next_diff
  FROM logs
) 
SELECT id, dt
FROM diffs
WHERE prev_diff > 1 or next_diff > 1;

Subquery Scan on diffs (cost=159..249)
  Filter
  -> WindowAgg
    -> Sort
      Sort Key: logs.dt
      -> Seq Scan on logs

letters (id, date, child_id, toy_id)
children (id, name, country_id)
country (id, name)
toy (id, name, category)

SELECT t.name, c.name, COUNT(*) AS count_toys
FROM country AS c
  JOIN children AS ch
    ON ch.country_id = c.id
  JOIN letters as l
    ON l.child_id = ch.id
  JOIN toy as t
    ON t.id = l.toy_id
WHERE l.date > '2023-01-01'
GROUP BY t.name, c.name

JOIN letters as l
  ON l.child_id = ch.id
  AND l.date > '2023-01-01'

from pyspark.sql import SparkSession

spark = (SparkSession.builder
  .appName("SparkExample")
  .master("yarn")
  .config("spark.some.config.option", "config-value")
  .enableHiveSupport()
  .getOrCreate()
)

import org.apache.spark.sql.SparkSession

val spark = SparkSession.builder()
  .appName("SparkExample")
  .master("yarn")
  .config("spark.some.config.option", "config-value")
  .enableHiveSupport()
  .getOrCreate()

spark = SparkSession.builder \
  .appName("SparkExample") \
  ...

spark = (SparkSession.builder
  .appName("SparkExample")
  ...
)

CREATE TABLE #localTempTable (...)

CREATE TABLE ##globalTempTable (...)