EasyNo. 2990LeetCode Premium
Loan Types — LeetCode 2990 Python Solution
- Topics
- Database
- Reading time
- 2 min
- Source
- leetcode.com
Table schema
Table: Loans +-------------+---------+ | Column Name | Type | +-------------+---------+ | loan_id | int | | user_id | int | | loan_type | varchar | +-------------+---------+ loan_id is column of unique values for this table. This table contains loan_id, user_id, and loan_type.Example
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| loan_id | int |
| user_id | int |
| loan_type | varchar |
+-------------+---------+
loan_id is column of unique values for this table.
This table contains loan_id, user_id, and loan_type.Python solution
import duckdb
import pandas as pd
def solution(loans: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Loans", loans)
return con.execute("""SELECT user_id
FROM Loans
GROUP BY 1
HAVING SUM(loan_type = 'Refinance') > 0 AND SUM(loan_type = 'Mortgage') > 0
ORDER BY 1;""").df()Complexity
- Time
- O(n log n)(typical)
- Space · auxiliary
- O(n)
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 0175 | Combine Two Tables | Easy |
| 0176 | Second Highest Salary | Medium |
| 0177 | Nth Highest Salary | Medium |
| 0178 | Rank Scores | Medium |
| 0180 | Consecutive Numbers | Medium |
| 0181 | Employees Earning More Than Their Managers | Easy |
Frequently asked questions
- How hard is LeetCode 2990. Loan Types?
LeetCode 2990. Loan Types is rated Easy on LeetCode.
- What topics does LeetCode 2990. Loan Types cover?
LeetCode 2990. Loan Types is tagged Database on LeetCode.
- Is LeetCode 2990. Loan Types a premium problem?
Yes. LeetCode 2990. Loan Types is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.