You learned joins. You can connect tables. Now you have a problem that requires multiple steps. First find the average salary per department. Then find employees who earn above their department average. One query cannot do this directly because you need the result of one calculation as input to another. Two solutions exist. Subqueries nest one query inside another. CTEs give each step a name and build them sequentially. Both solve the same problem. CTEs do it without making you want to delete your laptop. Subqueries: A Query Inside a Query A subquery is a SELECT statement wrapped in parentheses and embedded inside another query. import sqlite3 import pandas as pd conn = sqlite3 . connect ( " company.db " ) conn .…