Filtering Expensive Orders

Problem

The loyalty department wants to flag large transactions for fraud checks. Retrieve all columns from the orders table where the amount is strictly greater than 100.

Database Schema

Table: customers

• customer_id (INT): Unique identifier for the customer.
• first_name (VARCHAR): First name.
• last_name (VARCHAR): Last name.

Table: products

• product_id (INT): Unique identifier for the product.
• name (VARCHAR): Product name.
• price (DECIMAL): Product price.
• category (VARCHAR): Product category.

Table: orders

• order_id (INT): Unique identifier for the order.
• customer_id (INT): Foreign key referencing the customer.
• order_date (DATE): Date of the order.
• amount (DECIMAL): Total order amount.

Try It

Hint

Solution