Company: Msci_30july
Difficulty: medium
Problem Description A company's HR department needs a SQL query to retrieve data on the top-performing, verified freelancers from their hiring platform. Schema Table: profiles +-------------+--------------+----------------------------------+ | Column Name | Type | Description | +-------------+--------------+----------------------------------+ | id | SMALLINT | Unique ID, primary key | | first_name | VARCHAR(255) | First name of the freelancer | | last_name | VARCHAR(255) | Last name of the freelancer | | email | VARCHAR(255) | Email address | | is_verified | SMALLINT | 1 = True (Verified), 0 = False | +-------------+--------------+----------------------------------+ Table: stats +-------------------+----------+-----------------------------------+ | Column Name | Type | Description | +-------------------+----------+-----------------------------------+ | profile_id | SMALLINT | Foreign key references profiles.id| | job_success_score | SMALLINT | Job Success Score (JSS) | +---------------