Given two dataframes (df1: id, name and df2: id, country, address, city, count), join them, filter for rows where country = 'Singapore', and pivot the output. Sort cities in descending order of population count
SQLmedium
1042
Given two tables, calculate the row count for different types of joins (inner, left, right, and full outer)
SQLmedium
1043
HAVING vs WHERE - explain
SQLeasy
1044
Handle nulls, duplicates, and inconsistent timestamp formats in data.
SQLmedium
1045
Hierarchical Employee-Manager Query - navigate hierarchy with head of company as employee_id = 1
SQLmedium
1046
How can you automate data insertion into BigQuery using Python?
SQLhard
1047
How can you delete partitions from a table in Hive using a command?
SQLmedium
1048
How did you manage a situation where you lacked knowledge for a task?
SQLhard
+20 More Questions with Expert Answers
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.