export const deletedLinesSql = (alias: string) => {
    return `
      (SELECT COUNT(*) AS DELETED_COUNT
      FROM SALES_LINE_ITEM
      WHERE DELETED = 1 AND DATA_FILE_SID = ${alias}.DATA_FILE_SID
      GROUP BY DATA_FILE_SID)
    `;
  };
  
//customer sid and data file sid must be sent as arguments, what is alias here?, i think orm framework manages the execution