SQL for Actuaries

Practice SQL queries with actuarial database scenarios and examples.

Problem 1: Query Policy Data

Easy

Description

Write a SQL query to select all policies from the policies table where the premium is greater than 1000.

Database Schema

policies (
  policy_id INT,
  policy_holder_name VARCHAR(100),
  premium DECIMAL(10,2),
  start_date DATE,
  status VARCHAR(20)
)

Example Output

Should return all columns for policies with premium > 1000

SQL Editor
Query Results

Click "Run" to execute your query

Problems