Advanced Query

Write custom SQL queries and analyze your healthcare data

Column	Type	Description
`patient_id`	INT	Primary key
`first_name`	VARCHAR(50)	Patient's first name
`last_name`	VARCHAR(50)	Patient's last name
`date_of_birth`	DATE	Patient's birth date
`gender`	VARCHAR(10)	Patient's gender
`registration_date`	DATE	When patient was registered
`last_visit_date`	DATE	Date of last visit

Column	Type	Description
`appointment_id`	INT	Primary key
`patient_id`	INT	Foreign key to patients
`physician_id`	INT	ID of physician
`department`	VARCHAR(50)	Department name
`appointment_date`	DATETIME	Date and time of appointment
`status`	VARCHAR(20)	Status (scheduled, completed, cancelled, etc.)
`wait_time`	INT	Wait time in minutes

Column	Type	Description
`medication_id`	INT	Primary key
`name`	VARCHAR(100)	Medication name
`category`	VARCHAR(50)	Medication category
`cost`	DECIMAL(10,2)	Cost price
`price`	DECIMAL(10,2)	Selling price
`manufacturer`	VARCHAR(100)	Manufacturer name

SQL Query

Analyze Results

Analysis Type

Metric Name

Metric Description

Results

Run a query to see results

Saved Queries

Monthly Revenue Trend

Revenue analysis by month

Medication Response Rates

Comparing medication efficacy

Department Wait Times

Average wait times by department

Patient Demographics

Age and gender distribution

Query History

SELECT * FROM patients LIMIT 10

10 rows returned in 0.3s

SELECT COUNT(*) FROM appointments WHERE...

1 row returned in 0.5s

SELECT department, AVG(wait_time) FROM...

4 rows returned in 0.8s