• as already mentioned, pls provide create table, insert data and expected results.