Intel Interview Questions (7+ Questions)

Query a SQLite database table using Python's sqlite3 module, fetch all records, and export the results to a CSV file with proper headers.

def daily_temperatures(temperatures: list[int]) -> list[int]:
res = [0] * len(temperatures)
stack = [] # Stores indices

for i, t in enumerate(temperatures):
    while stack and t > temperatures[stack[-1]]:
        prev_index = stack.pop()
        res[prev_index] = i - prev_index
    stack.append(i)
    
return res

def search(nums: list[int], target: int) -> int:
l, r = 0, len(nums) - 1

while l <= r:
    m = (l + r) // 2
    if nums[m] > target:
        r = m - 1
    elif nums[m] < target:
        l = m + 1
    else:
        return m
return -1

How to Answer Terraform Configuration Interview Questions Effectively

When working on a cloud infrastructure project, particularly one requiring dynamic resource naming and tracking, your ability to create a well-structured data organization system is crucial. In a Terraform configuration, this...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Execute SQL queries with multi-table JOINs in SQLite, load results into pandas, perform calculations including aggregations and percentages, and export to CSV format.

WITH joined AS (
SELECT
pr.product_id,
pr.manufacturing_date,
pr.manufacturing_location,
p.product_name,
p.product_type
FROM {{ ref("production_records") }} pr
INNER JOIN {{ ref("products") }} p
ON pr.product_id = p.product_id
)
SELECT
product_id,
manufacturing_date,
manufacturing_location,
product_name,
product_type,
ROW_NUMBER() OVER (ORDER BY manufacturing_date ASC) AS row_number
FROM joined

SELECT
t.trans_id,
t.trans_amt,
t.date,
c.cust_id,
c.first_name,
c.last_name,
c.age
FROM {{ ref("transactions") }} t
CROSS JOIN {{ ref("customers") }} c