Explain Inner Joins

What's an inner join?

Write a PostgreSQL query that demonstrates an inner join between employees and access_cards. Return only records where an employee has a matching access card. Do not include employees without cards or cards without a matching employee.

Output

1. One row per matching employee and access card
2. Columns: employee_id, employee_name, card_id, and card_status
3. Sort by employee_id ascending, then card_id ascending