SHR

SELECT shr(16, 4);

create.select(shr(16, 4)).fetch();

+-----+
| shr |
+-----+
|   1 |
+-----+

shr(16, 4)

-- ASE, HSQLDB, SQLDATAWAREHOUSE, SYBASE
(16 / CAST(power(2, 4) AS int))

-- AURORA_MYSQL, AURORA_POSTGRES, BIGQUERY, COCKROACHDB, DUCKDB, MARIADB, MEMSQL, MYSQL, POSTGRES, REDSHIFT, SQLITE, 
-- SQLSERVER, VERTICA, YUGABYTEDB
(16 >> 4)

-- DB2, INFORMIX
(16 / CAST(power(2, 4) AS integer))

-- EXASOL
bit_rshift(16, 4)

-- FIREBIRD
bin_shr(16, 4)

-- H2
rshift(16, 4)

-- ORACLE
(16 / CAST(power(2, 4) AS number(10)))

-- SNOWFLAKE
bitshiftright(16, 4)

-- TERADATA
shiftright(16, 4)

-- TRINO
bitwise_right_shift(16, 4)

-- ACCESS, DERBY, HANA
/* UNSUPPORTED */