How to organize sorting?

Question

SQL

There are two types of articles: video and text. Question: is it possible to sort by date of addition and type of article
article with video, after it 2 articles with text, and so on in a cycle, if there are no more articles with video, then simply display text articles.

Answer 1

SELECT * FROM (
  SELECT 
    table.*,
    CASE 
      WHEN type='video' THEN row_number() OVER (PARTITION BY type ORDER BY create_date) *2 
      ELSE row_number() OVER (PARTITION BY type ORDER BY create_date) +1
      END ord
    FROM table
) result ORDER BY ord, type DESC

analytics is standard, should work on any DBMS