How can I query specific date data?

[md-siam]

My table is shown below:

await db.execute(
          '''
          CREATE TABLE IF NOT EXISTS $maintransaction(
            id TEXT PRIMARY KEY NOT NULL,
            userId TEXT NOT NULL,
            walletId TEXT NOT NULL,
            selectCategoryId TEXT NOT NULL,
            currencyId TEXT NOT NULL,
            transactionCategoryId TEXT NOT NULL,
            eventId TEXT NOT NULL,
            currencyCode TEXT NOT NULL,
            currencySymbol TEXT NOT NULL,
            transactionAmount REAL NOT NULL,
            isCredit INTEGER NOT NULL,
            isDebit INTEGER NOT NULL,
            transactionDate TEXT NOT NULL,
            transactionWith TEXT NOT NULL,
            transactionNote TEXT NOT NULL,
            reminderTime TEXT NOT NULL,
            selectCategoryImage TEXT NOT NULL,
            createdAt TEXT,
            updatedAt TEXT NOT NULL)
          ''',
        );

I want to query using the transactionDate, to get all the transactions that happened last month.