Business

How to insert MAX (text) as WHERE clause?

I should be searching based on two WHERE clauses at the same time. One is a simple clause, the other is MAX (text). How to solve?

x = cursor.execute('SELECT product FROM electronics WHERE brand = ? AND MAX(price)' [combo_brand])

Price is a column of a database. I want to take the highest value of the column records. I would like to select the product with the maximum price, and search by it and by brand at the same time.

I am getting this error:

TypeError: string indices must be integers