SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();


sqlite_version()


3.27.2


create table tbl (df INT, tf INT)
INSERT INTO tbl VALUES (3,5);
INSERT INTO tbl VALUES (2,6);
INSERT INTO tbl VALUES (2,2);
INSERT INTO tbl VALUES (4,6);
INSERT INTO tbl VALUES (1,1);
INSERT INTO tbl VALUES (6,6);
INSERT INTO tbl VALUES (6,16);
INSERT INTO tbl VALUES (4,20);
SELECT df, tf, 
  CASE 
    WHEN tf >6 THEN df||'/'||'6'
    ELSE df||'/'||tf
    END AS fruits_fraction
FROM tbl


df
tf
fruits_fraction


3
5
3/5

2
6
2/6

2
2
2/2

4
6
4/6

1
1
1/1

6
6
6/6

6
16
6/6

4
20
4/6