Company: Cognizant
Difficulty: medium
Database Query Question Problem A travel/ticketing application records every payment made against a booking in a single table named `PAYMENTS`. Write an SQL query to display the **payment ID**, **booking ID**, **amount**, and **payment method** of all payment records where the payment method used was a **card** (for example a credit card or a debit card) and the **amount is greater than 22.50**. Schema ### Table: `PAYMENTS` | Column | Type | Description | |------------------|-----------------|-----------------------------------------------------------------------------| | `PAYMENT_ID` | `INTEGER` | Primary key. Unique identifier of the payment record. | | `BOOKING_ID` | `INTEGER` | Identifier of the booking this payment settles. `NOT NULL`. | | `AMOUNT` | `DECIMAL(10,2)` | Amount paid, in currency units. `NOT NULL`. | | `PAYMENT_METHOD` | `VARCHAR(50)` | How the payment was made, e.g. `Credit Card`, `Debit Card`, `Cash`, `UPI`, `Net Banking`, `Cheque`. May be `NULL` when the method was