Calcualting Medians in SQL

I am trying to figure out how to calculate MEDIAN in GROUPS within SQL (i.e. required to use NTILE() functions to indirectly calculate the median).

Finding out the cumulative number of missing rows per group

I have this table in SQL about the years in which students were studying in a school:

SQL: Finding out the cumulative number of missing rows per group

I have this table in SQL about the years in which students were studying in a school:

SQL: Comparing Identical Rows in Different Tables and then Updating

I have these two tables : old_table was created on 2020-01-01 and new_table was created on 2020-01-02.

SQL; Ensuring a Condition is Met After the Join

I have these two tables:

SQL: Counting Number of Occurrences Past a Certain Date

I have these two tables:

SQL: Joining Most Recent Row to Another Table

I have the two following tables:

SQL: Join based on closest date

I have the two following tables: