Tools Borrowed Only in Spring

Problem

A community tool library tracks every time a tool is lent out.

Table: tool
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| tool_id | int |
| tool_name | varchar |
| deposit | int |
+-------------+---------+
tool_id is the primary key. Each row names a tool and its deposit amount.

Table: loan
+-------------+------+
| Column Name | Type |
+-------------+------+
| clerk_id | int |
| tool_id | int |
| borrower_id | int |
| lent_on | date |
| nights | int |
| fee | int |
+-------------+------+
This table may contain duplicate rows. Each row records one loan of a tool. tool_id references the tool table.

Write a solution that reports the tools that were lent out only during spring 2022, meaning between 2022-03-01 and 2022-05-31 inclusive and on no other dates. Return the result in any order with columns tool_id and tool_name.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns tool_id, tool_name.

Starter code (SQL)

SELECT *
FROM tool;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy