My issue
Write a query to output the customer id of all distinct users whose name end with the letter ‘a’.
Expected output
┌─────────────┐
│ customer_id │
├─────────────┤
│ 12445 │
│ 12345 │
│ 22213 │
│ 22217 │
│ 22219 │
└─────────────┘
Your database is named ‘Orders’ and has the following columns
order_id (INT)
order_time (DOUBLE)
customer_id (VARCHAR)
customer_name (VARCHAR)
address_pincode (INT)
apartment_floor (INT)
My code
/* Write a query to output the userids of all distinct users whose name end with the letter 'a' */
Learning course: Database management systems
Problem Link: Project - Distinct with name pattern in Database management systems