Filtering Patients by Gender in a Hospital Database

Your challenge is to write an SQL query to show the first name, last name, and gender of patients whose gender is 'M'.

Database Structure

You'll be using the hospital.sqlite database, specifically the patients table. The table contains various columns, but you'll need to focus on the following fields:

• first_name
• last_name
• gender

Concepts Covered

• Basic SQL SELECT statements
• WHERE clause for filtering data

Good luck!