Filtering Patients by Specific IDs in a Hospital Database

The database focuses on hospital data, and for this particular exercise you'll be using the patients table.

Schema

patients table schema

• patient_id
• first_name
• last_name
• gender
• birth_date
• city
• province_id
• allergies
• height
• weight

Task

Write a SQL query to show all columns for patients who have specific patient_ids: 1, 45, 534, 879, 1000.

Concepts to Know

• SELECT: To specify the columns you want to retrieve.
• WHERE: To filter the records based on certain conditions.
• IN: To specify multiple values in a WHERE clause.

Remember, the focus here is not just on getting the right answer, but also on understanding the SQL concepts being applied.

Good luck!